Excel export options in React Grid component
3 Sep 202424 minutes to read
The Syncfusion React Grid component allows you to customize the Excel or CSV export options functionality. This flexibility enables you to have greater control over the exported content and layout to meet your specific requirements.
The Excel or CSV export action can be customized based on your requirements using the excelExportProperties property. By using the excelExportProperties
property, you can export specific columns, exclude or include hidden column, export with custom data source, enable filter in the exported excel or CSV file, change the file name, add header and footer, multiple grid exporting, customize the data based on query, define delimiter for CSV exporting and set the theme.
Export current page records
Exporting the current page in Syncfusion React Grid to a Excel or CSV document provides the ability to export the currently displayed page records. This feature allows for generating Excel or CSV documents that specifically include the content from the current page of the grid.
To export the current page of the grid to an Excel or CSV document, you need to specify the exportType property. This property allows you to define which records you want to export. You can choose between two options:
- CurrentPage: Exports only the records on the current grid page.
- AllPages: Exports all the records from the grid.
The following example demonstrates how to export current page to a Excel document when a toolbar item is clicked.
import { DropDownListComponent } from '@syncfusion/ej2-react-dropdowns';
import { ColumnDirective, ColumnsDirective, ExcelExport, GridComponent } from '@syncfusion/ej2-react-grids';
import { Inject, Page, Toolbar } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { employeeData } from './datasource';
function App() {
let grid;
let dropDown;
const dropDownData = [
{ text: 'CurrentPage', value: 'CurrentPage' },
{ text: 'AllPages', value: 'AllPages' },
];
const toolbar = ['ExcelExport'];
const pageOptions = { pageSize: 6 };
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') { // 'Grid_pdfexport' -> Grid component id + _ + toolbar item name
const exportProperties = {
exportType: dropDown.value
};
grid.excelExport(exportProperties);
}
}
return (
<div>
<label style={{ padding: "10px 10px 26px 0" }}> Change export type: </label>
<DropDownListComponent ref={d => dropDown = d} index={0} width={170} dataSource={dropDownData}></DropDownListComponent>
<GridComponent id='Grid' dataSource={employeeData} toolbar={toolbar} allowExcelExport={true}
toolbarClick={toolbarClick} ref={g => grid = g} allowPaging={true} pageSettings={pageOptions}>
<ColumnsDirective>
<ColumnDirective field='EmployeeID' headerText='Employee ID' width='120' textAlign='Right' />
<ColumnDirective field='FirstName' headerText='FirstName' width='150' />
<ColumnDirective field='LastName' headerText='LastName' width='150' />
<ColumnDirective field='City' headerText='City' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport, Page]} />
</GridComponent>
</div>
);
}
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-react-navigations';
import { DropDownListComponent } from '@syncfusion/ej2-react-dropdowns';
import { ColumnDirective, ColumnsDirective, ExcelExport, ExcelExportProperties, GridComponent, PageSettingsModel, ToolbarItems } from '@syncfusion/ej2-react-grids';
import { Inject, Page, Toolbar } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { employeeData } from './datasource';
function App() {
let grid: GridComponent | null;
let dropDown: DropDownListComponent | null;
const dropDownData: { [key: string]: Object; }[] = [
{ text: 'CurrentPage', value: 'CurrentPage' },
{ text: 'AllPages', value: 'AllPages' },
];
const toolbar: ToolbarItems[] = ['ExcelExport'];
const pageOptions: PageSettingsModel = { pageSize: 6 };
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'Grid_excelexport') { // 'Grid_pdfexport' -> Grid component id + _ + toolbar item name
const exportProperties: ExcelExportProperties = {
exportType: (dropDown as DropDownListComponent).value
};
grid.excelExport(exportProperties);
}
}
return (
<div>
<label style={{ padding: "10px 10px 26px 0" }}> Change export type: </label>
<DropDownListComponent ref={d => dropDown = d} index={0} width={170} dataSource={dropDownData}></DropDownListComponent>
<GridComponent id='Grid' dataSource={employeeData} toolbar={toolbar} allowExcelExport={true}
toolbarClick={toolbarClick} ref={g => grid = g} allowPaging={true} pageSettings={pageOptions}>
<ColumnsDirective>
<ColumnDirective field='EmployeeID' headerText='Employee ID' width='120' textAlign='Right' />
<ColumnDirective field='FirstName' headerText='FirstName' width='150' />
<ColumnDirective field='LastName' headerText='LastName' width='150' />
<ColumnDirective field='City' headerText='City' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport, Page]} />
</GridComponent>
</div>
);
}
export default App;
export let employeeData = [{
'EmployeeID': 1,
'LastName': 'Davolio',
'FirstName': 'Nancy',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-664743600000),
'HireDate': new Date(704692800000),
'Address': '507 - 20th Ave. E.\r\nApt. 2A',
'City': 'Seattle',
'Region': 'WA',
'PostalCode': '98122',
'Country': 'USA',
'HomePhone': '(206) 555-9857',
'Extension': '5467',
'Photo': { 'Length': 21626 },
'Notes': 'Education includes a BA in psychology from Colorado State University in 1970. She also completed\
\'The Art of the Cold Call.\' Nancy is a member of Toastmasters International.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 2,
'LastName': 'Fuller',
'FirstName': 'Andrew',
'Title': 'Vice President, Sales',
'TitleOfCourtesy': 'Dr.',
'BirthDate': new Date(-563828400000),
'HireDate': new Date(713764800000),
'Address': '908 W. Capital Way',
'City': 'Tacoma',
'Region': 'WA',
'PostalCode': '98401',
'Country': 'USA',
'HomePhone': '(206) 555-9482',
'Extension': '3457',
'Photo': { 'Length': 21626 },
'Notes': 'Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of \
Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, \
was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the \
Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.',
'ReportsTo': 0,
'PhotoPath': 'http://accweb/emmployees/fuller.bmp'
},
{
'EmployeeID': 3,
'LastName': 'Leverling',
'FirstName': 'Janet',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-200088000000),
'HireDate': new Date(702104400000),
'Address': '722 Moss Bay Blvd.',
'City': 'Kirkland',
'Region': 'WA',
'PostalCode': '98033',
'Country': 'USA',
'HomePhone': '(206) 555-3412',
'Extension': '3355',
'Photo': { 'Length': 21722 },
'Notes': 'Janet has a BS degree in chemistry from Boston College (1984). \
She has also completed a certificate program in food retailing management.\
Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/leverling.bmp'
},
{
'EmployeeID': 4,
'LastName': 'Peacock',
'FirstName': 'Margaret',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Mrs.',
'BirthDate': new Date(-1018814400000),
'HireDate': new Date(736401600000),
'Address': '4110 Old Redmond Rd.',
'City': 'Redmond',
'Region': 'WA',
'PostalCode': '98052',
'Country': 'USA',
'HomePhone': '(206) 555-8122',
'Extension': '5176',
'Photo': { 'Length': 21626 },
'Notes': 'Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American \
Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/peacock.bmp'
},
{
'EmployeeID': 5,
'LastName': 'Buchanan',
'FirstName': 'Steven',
'Title': 'Sales Manager',
'TitleOfCourtesy': 'Mr.',
'BirthDate': new Date(-468010800000),
'HireDate': new Date(750830400000),
'Address': '14 Garrett Hill',
'City': 'London',
'Region': null,
'PostalCode':
'SW1 8JR',
'Country': 'UK',
'HomePhone': '(71) 555-4848',
'Extension': '3453',
'Photo': { 'Length': 21626 },
'Notes': 'Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as \
a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent \
post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses \'Successful \
Telemarketing\' and \'International Sales Management.\' He is fluent in French.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/buchanan.bmp'
},
{
'EmployeeID': 6,
'LastName': 'Suyama',
'FirstName': 'Michael',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Mr.',
'BirthDate': new Date(-205185600000),
'HireDate': new Date(750830400000),
'Address': 'Coventry House\r\nMiner Rd.',
'City': 'London',
'Region': null,
'PostalCode': 'EC2 7JR',
'Country': 'UK',
'HomePhone': '(71) 555-7773',
'Extension': '428',
'Photo': { 'Length': 21626 },
'Notes': 'Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles \
(MBA, marketing, 1986). He has also taken the courses \'Multi-Cultural Selling\' and \'Time Management for the Sales Professional.\' \
He is fluent in Japanese and can read and write French, Portuguese, and Spanish.',
'ReportsTo': 5,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 7,
'LastName': 'King',
'FirstName': 'Robert',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Mr.',
'BirthDate': new Date(-302731200000),
'HireDate': new Date(757486800000),
'Address': 'Edgeham Hollow\r\nWinchester Way',
'City': 'London',
'Region': null,
'PostalCode': 'RG1 9SP',
'Country': 'UK',
'HomePhone': '(71) 555-5598',
'Extension': '465',
'Photo': { 'Length': 21626 },
'Notes': 'Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the \
University of Michigan in 1992, the year he joined the company. After completing a course entitled \'Selling in Europe,\' \
he was transferred to the London office in March 1993.',
'ReportsTo': 5,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 8,
'LastName': 'Callahan',
'FirstName': 'Laura',
'Title': 'Inside Sales Coordinator',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-377982000000),
'HireDate': new Date(762843600000),
'Address': '4726 - 11th Ave. N.E.',
'City': 'Seattle',
'Region': 'WA',
'PostalCode': '98105',
'Country': 'USA',
'HomePhone': '(206) 555-1189',
'Extension': '2344',
'Photo': { 'Length': 21626 },
'Notes': 'Laura received a BA in psychology from the University of Washington. She has also completed a course in business \
French. She reads and writes French.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 9,
'LastName': 'Dodsworth',
'FirstName': 'Anne',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-123966000000),
'HireDate': new Date(784875600000),
'Address': '7 Houndstooth Rd.',
'City': 'London',
'Region': null,
'PostalCode': 'WG2 7LT',
'Country': 'UK',
'HomePhone': '(71) 555-4444',
'Extension': '452',
'Photo': { 'Length': 21626 },
'Notes': 'Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.',
'ReportsTo': 5,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
}];
export let employeeData: Object[] = [{
'EmployeeID': 1,
'LastName': 'Davolio',
'FirstName': 'Nancy',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-664743600000),
'HireDate': new Date(704692800000),
'Address': '507 - 20th Ave. E.\r\nApt. 2A',
'City': 'Seattle',
'Region': 'WA',
'PostalCode': '98122',
'Country': 'USA',
'HomePhone': '(206) 555-9857',
'Extension': '5467',
'Photo': { 'Length': 21626 },
'Notes': 'Education includes a BA in psychology from Colorado State University in 1970. She also completed\
\'The Art of the Cold Call.\' Nancy is a member of Toastmasters International.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 2,
'LastName': 'Fuller',
'FirstName': 'Andrew',
'Title': 'Vice President, Sales',
'TitleOfCourtesy': 'Dr.',
'BirthDate': new Date(-563828400000),
'HireDate': new Date(713764800000),
'Address': '908 W. Capital Way',
'City': 'Tacoma',
'Region': 'WA',
'PostalCode': '98401',
'Country': 'USA',
'HomePhone': '(206) 555-9482',
'Extension': '3457',
'Photo': { 'Length': 21626 },
'Notes': 'Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of \
Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, \
was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the \
Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.',
'ReportsTo': 0,
'PhotoPath': 'http://accweb/emmployees/fuller.bmp'
},
{
'EmployeeID': 3,
'LastName': 'Leverling',
'FirstName': 'Janet',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-200088000000),
'HireDate': new Date(702104400000),
'Address': '722 Moss Bay Blvd.',
'City': 'Kirkland',
'Region': 'WA',
'PostalCode': '98033',
'Country': 'USA',
'HomePhone': '(206) 555-3412',
'Extension': '3355',
'Photo': { 'Length': 21722 },
'Notes': 'Janet has a BS degree in chemistry from Boston College (1984). \
She has also completed a certificate program in food retailing management.\
Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/leverling.bmp'
},
{
'EmployeeID': 4,
'LastName': 'Peacock',
'FirstName': 'Margaret',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Mrs.',
'BirthDate': new Date(-1018814400000),
'HireDate': new Date(736401600000),
'Address': '4110 Old Redmond Rd.',
'City': 'Redmond',
'Region': 'WA',
'PostalCode': '98052',
'Country': 'USA',
'HomePhone': '(206) 555-8122',
'Extension': '5176',
'Photo': { 'Length': 21626 },
'Notes': 'Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American \
Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/peacock.bmp'
},
{
'EmployeeID': 5,
'LastName': 'Buchanan',
'FirstName': 'Steven',
'Title': 'Sales Manager',
'TitleOfCourtesy': 'Mr.',
'BirthDate': new Date(-468010800000),
'HireDate': new Date(750830400000),
'Address': '14 Garrett Hill',
'City': 'London',
'Region': null,
'PostalCode':
'SW1 8JR',
'Country': 'UK',
'HomePhone': '(71) 555-4848',
'Extension': '3453',
'Photo': { 'Length': 21626 },
'Notes': 'Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as \
a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent \
post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses \'Successful \
Telemarketing\' and \'International Sales Management.\' He is fluent in French.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/buchanan.bmp'
},
{
'EmployeeID': 6,
'LastName': 'Suyama',
'FirstName': 'Michael',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Mr.',
'BirthDate': new Date(-205185600000),
'HireDate': new Date(750830400000),
'Address': 'Coventry House\r\nMiner Rd.',
'City': 'London',
'Region': null,
'PostalCode': 'EC2 7JR',
'Country': 'UK',
'HomePhone': '(71) 555-7773',
'Extension': '428',
'Photo': { 'Length': 21626 },
'Notes': 'Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles \
(MBA, marketing, 1986). He has also taken the courses \'Multi-Cultural Selling\' and \'Time Management for the Sales Professional.\' \
He is fluent in Japanese and can read and write French, Portuguese, and Spanish.',
'ReportsTo': 5,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 7,
'LastName': 'King',
'FirstName': 'Robert',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Mr.',
'BirthDate': new Date(-302731200000),
'HireDate': new Date(757486800000),
'Address': 'Edgeham Hollow\r\nWinchester Way',
'City': 'London',
'Region': null,
'PostalCode': 'RG1 9SP',
'Country': 'UK',
'HomePhone': '(71) 555-5598',
'Extension': '465',
'Photo': { 'Length': 21626 },
'Notes': 'Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the \
University of Michigan in 1992, the year he joined the company. After completing a course entitled \'Selling in Europe,\' \
he was transferred to the London office in March 1993.',
'ReportsTo': 5,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 8,
'LastName': 'Callahan',
'FirstName': 'Laura',
'Title': 'Inside Sales Coordinator',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-377982000000),
'HireDate': new Date(762843600000),
'Address': '4726 - 11th Ave. N.E.',
'City': 'Seattle',
'Region': 'WA',
'PostalCode': '98105',
'Country': 'USA',
'HomePhone': '(206) 555-1189',
'Extension': '2344',
'Photo': { 'Length': 21626 },
'Notes': 'Laura received a BA in psychology from the University of Washington. She has also completed a course in business \
French. She reads and writes French.',
'ReportsTo': 2,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
'EmployeeID': 9,
'LastName': 'Dodsworth',
'FirstName': 'Anne',
'Title': 'Sales Representative',
'TitleOfCourtesy': 'Ms.',
'BirthDate': new Date(-123966000000),
'HireDate': new Date(784875600000),
'Address': '7 Houndstooth Rd.',
'City': 'London',
'Region': null,
'PostalCode': 'WG2 7LT',
'Country': 'UK',
'HomePhone': '(71) 555-4444',
'Extension': '452',
'Photo': { 'Length': 21626 },
'Notes': 'Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.',
'ReportsTo': 5,
'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
}];
Export the selected records
Exporting only the selected records from the Grid allows generating Excel or CSV document that include only the desired data from the Grid. This feature provides the flexibility to export specific records that are relevant to the needs, enabling more focused and targeted Excel or CSV exports.
To export only the selected records by utilizing the exportProperties.dataSource
property in the toolbarClick
event.
To export the selected records from the grid to a Excel or CSV file, you can follow these steps:
-
Handle the toolbarClick event of the Grid.
-
Retrieve the selected records using the getSelectedRecords method.
-
Assign the selected data to the exportProperties.dataSource property.
-
Trigger the export operation using the excelExport or csvExport method.
The following example demonstrates how to export the selected records to a Excel document when a toolbar item is clicked.
import { ColumnDirective, ColumnsDirective, GridComponent, Inject } from '@syncfusion/ej2-react-grids';
import { Page, Toolbar, ExcelExport } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid;
const selectionOptions = { type: 'Multiple', enableSimpleMultiRowSelection: true };
const toolbar = ['ExcelExport'];
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') {
const selectedRecords = grid.getSelectedRecords();
const exportProperties = {
dataSource: selectedRecords
};
grid.excelExport(exportProperties);
}
}
return (<GridComponent id='Grid' dataSource={data} allowPaging={true} allowExcelExport={true} toolbar={toolbar} selectionSettings={selectionOptions} toolbarClick={toolbarClick}
ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='100' textAlign="Right" isPrimaryKey={true} />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='120' />
<ColumnDirective field='Freight' headerText='Freight' width='120' format="C2" textAlign="Right" />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='150' />
</ColumnsDirective>
<Inject services={[Page, Toolbar, ExcelExport]} />
</GridComponent>)
};
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { ColumnDirective, ColumnsDirective, GridComponent, Inject } from '@syncfusion/ej2-react-grids';
import { Page, Toolbar, ToolbarItems, ExcelExport, ExcelExportProperties, SelectionSettingsModel } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid: GridComponent | null;
const selectionOptions: SelectionSettingsModel = { type: 'Multiple', enableSimpleMultiRowSelection: true };
const toolbar: ToolbarItems[] = ['ExcelExport'];
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'Grid_excelexport') {
const selectedRecords = grid.getSelectedRecords();
const exportProperties: ExcelExportProperties = {
dataSource: selectedRecords
};
grid.excelExport(exportProperties);
}
}
return (<GridComponent id='Grid' dataSource={data} allowPaging={true} allowExcelExport={true} toolbar={toolbar} selectionSettings={selectionOptions} toolbarClick={toolbarClick}
ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='100' textAlign="Right" isPrimaryKey={true} />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='120' />
<ColumnDirective field='Freight' headerText='Freight' width='120' format="C2" textAlign="Right" />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='150' />
</ColumnsDirective>
<Inject services={[Page, Toolbar, ExcelExport]} />
</GridComponent>)
};
export default App;
export let data = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}
];
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
Exporting grouped records
The Grid component provides an outline option for grouped records, allowing you to hide detailed data for better viewing in the exported document. This feature is particularly useful when you need to share data that is grouped based on specific columns and maintain the grouping structure in the exported file.
To achieve this functionality, you need to enable grouping in the Grid by setting the allowGrouping property to true . Additionally, you need define the groupSettings.columns property to specify the columns by which you want to group the data.
The following example demonstrates how to export grouped records to an Excel document when a toolbar item is clicked.:
import { ColumnDirective, ColumnsDirective, GridComponent } from '@syncfusion/ej2-react-grids';
import { ExcelExport, Group, Inject, Toolbar, Page } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid;
const toolbar = ['ExcelExport'];
const groupOptions = {
columns: ['CustomerID', 'ShipCity']
};
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') {
grid.excelExport();
}
};
return (<div>
<GridComponent id='Grid' dataSource={data} height={270} toolbar={toolbar} allowPaging={true} allowGrouping={true} allowExcelExport={true} toolbarClick={toolbarClick} ref={g => grid = g} groupSettings={groupOptions}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right'/>
<ColumnDirective field='CustomerID' headerText='Customer ID' width='150'/>
<ColumnDirective field='ShipCity' headerText='Ship City' width='150'/>
<ColumnDirective field='ShipName' headerText='Ship Name' width='150'/>
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport, Group, Page]}/>
</GridComponent>
</div>);
}
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { ColumnDirective, ColumnsDirective, GridComponent, ToolbarItems } from '@syncfusion/ej2-react-grids';
import { ExcelExport, Group, GroupSettingsModel, Inject, Toolbar, Page } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid: GridComponent | null;
const toolbar: ToolbarItems[] = ['ExcelExport'];
const groupOptions : GroupSettingsModel = {
columns: ['CustomerID', 'ShipCity']
};
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'Grid_excelexport') {
grid.excelExport();
}
}
return (
<div>
<GridComponent id='Grid' dataSource={data} height={270} toolbar={toolbar} allowGrouping={true}
allowExcelExport={true} toolbarClick={toolbarClick} ref={g=> grid = g} groupSettings={groupOptions} allowPaging={true}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right'/>
<ColumnDirective field='CustomerID' headerText='Customer ID' width='150' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='150' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport, Group, Page]}/>
</GridComponent>
</div>
);
}
export default App;
export let data = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}
];
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
Export with hidden columns
Exporting hidden columns in the Syncfusion React Grid allows you to include hidden columns in the exported Excel document. This feature is useful when you have columns that are hidden in the UI but still need to be included in the exported document.
To export hidden columns of the grid to a Excel or CSV file, you need to set the includeHiddenColumn property as true in the excelExportProperties property.
The following example demonstrates how to export hidden columns to a Excel file. In this example, the ShipCity column, which is not visible in the UI, is exported to the Excel document. You can also export the grid by changing the excelExportProperties.includeHiddenColumn
property based on the switch toggle using the checked property of the EJ2 Toggle Switch Button component.
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { SwitchComponent } from '@syncfusion/ej2-react-buttons';
import { ColumnDirective, ColumnsDirective, ExcelExport, ExcelExportProperties, GridComponent, Inject } from '@syncfusion/ej2-react-grids';
import { Page, Toolbar, ToolbarItems } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid;
let switchData;
const toolbar = ['ExcelExport'];
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') {
const exportProperties = {
includeHiddenColumn: switchData.checked
};
grid.excelExport(exportProperties);
}
}
return (<div>
<label style={{ padding: "10px 10px" }}>Include or exclude hidden columns </label>
<SwitchComponent ref={s => switchData = s}></SwitchComponent>
<GridComponent id='Grid' dataSource={data} allowPaging={true} allowExcelExport={true} toolbar={toolbar} toolbarClick={toolbarClick} ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='100' textAlign="Right" />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='120' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='130' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='120' visible={false} />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='100' />
</ColumnsDirective>
<Inject services={[Page, Toolbar, ExcelExport]} />
</GridComponent></div>)
};
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { SwitchComponent } from '@syncfusion/ej2-react-buttons';
import { ColumnDirective, ColumnsDirective, ExcelExport, ExcelExportProperties, GridComponent, Inject } from '@syncfusion/ej2-react-grids';
import { Page, Toolbar, ToolbarItems } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid: GridComponent | null;
let switchData: SwitchComponent | null;
const toolbar: ToolbarItems[] = ['ExcelExport'];
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'Grid_excelexport') {
const exportProperties: ExcelExportProperties = {
includeHiddenColumn: (switchData as SwitchComponent).checked
};
grid.excelExport(exportProperties);
}
}
return (<div>
<label style={{ padding: "10px 10px" }}>Include or exclude hidden columns </label>
<SwitchComponent ref={s => switchData = s}></SwitchComponent>
<GridComponent id='Grid' dataSource={data} allowPaging={true} allowExcelExport={true} toolbar={toolbar} toolbarClick={toolbarClick} ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='100' textAlign="Right" />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='120' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='130' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='120' visible={false} />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='100' />
</ColumnsDirective>
<Inject services={[Page, Toolbar, ExcelExport]} />
</GridComponent></div>)
};
export default App;
export let data = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}
];
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
Show or hide columns while exporting
The Grid component provides the functionality to show or hide columns dynamically during the export process. This feature allows you to selectively display or hide specific columns based on your requirements.
To show or hide columns based on user interaction during the export process, you can follow these steps:
-
Handle the toolbarClick event of the Grid component.
-
Update the visibility of the desired columns by setting the visible property of the column to true or false.
-
Export the grid to Excel.
-
Handle the excelExportComplete event to restore the column visibility to its original state.
In the following example, the CustomerID is initially a hidden column in the grid. However, during the export process, the CustomerID column is made visible, while the ShipCity column is hidden.
import { ColumnDirective, ColumnsDirective, GridComponent } from '@syncfusion/ej2-react-grids';
import { ExcelExport, Inject, Toolbar } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid;
const toolbar = ['ExcelExport'];
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') {
grid.columns[1].visible = true;
grid.columns[3].visible = false;
grid.excelExport();
}
};
const excelExportComplete = () => {
if (grid) {
grid.columns[1].visible = false;
grid.columns[3].visible = true;
}
};
return (<div>
<GridComponent id='Grid' dataSource={data} height={270} toolbar={toolbar} allowExcelExport={true} toolbarClick={toolbarClick} ref={g => grid = g} excelExportComplete={excelExportComplete}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right'/>
<ColumnDirective field='CustomerID' headerText='Customer ID' visible={false} width='150'/>
<ColumnDirective field='ShipCity' headerText='Ship City' width='150'/>
<ColumnDirective field='ShipName' headerText='Ship Name' width='150'/>
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport]}/>
</GridComponent>
</div>);
}
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { ColumnDirective, ColumnsDirective, GridComponent, ToolbarItems } from '@syncfusion/ej2-react-grids';
import { Column, ExcelExport, Grid, Inject, Toolbar } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid: Grid | null;
const toolbar: ToolbarItems[] = ['ExcelExport'];
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'Grid_excelexport') {
(grid.columns[1] as Column).visible = true;
(grid.columns[3] as Column).visible = false;
grid.excelExport();
}
}
const excelExportComplete = (): void => {
if (grid) {
(grid.columns[1] as Column).visible = false;
(grid.columns[3] as Column).visible = true;
}
}
return (
<div>
<GridComponent id='Grid' dataSource={data} height={270} toolbar={toolbar}
allowExcelExport={true} toolbarClick={toolbarClick} ref={g=> grid = g}
excelExportComplete={excelExportComplete}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right'/>
<ColumnDirective field='CustomerID' headerText='Customer ID' visible={false} width='150' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='150' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport]}/>
</GridComponent>
</div>
);
}
export default App;
export let data = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}
];
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
Enable filtering in the exported excel file
The Grid allows you to export data to Excel or CSV with filter options and also export only filtered records. This feature is especially beneficial when you need to share data with others while preserving the ability for them to filter and analyze the data in Excel or CSV.
To enable this feature, you should set the enableFilter property to true in the excelExportProperties object. Additionally, you need to set allowFiltering to true in the grid configuration. This property enables filtering in the grid.
The following example demonstrates how to export data with filter options to an Excel document when a toolbar item is clicked:
import { ColumnDirective, ColumnsDirective, GridComponent } from '@syncfusion/ej2-react-grids';
import { ExcelExport, Inject, Toolbar, Filter } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid;
const toolbar = ['ExcelExport'];
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') {
const excelExportProperties = {
enableFilter: true
};
grid.excelExport(excelExportProperties);
}
};
return (<div>
<GridComponent id='Grid' dataSource={data} allowFiltering={true} height={270} toolbar={toolbar} allowExcelExport={true} toolbarClick={toolbarClick} ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right' />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='150' />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='100' visible={false} />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport, Filter]} />
</GridComponent>
</div>);
}
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { ColumnDirective, ColumnsDirective, GridComponent, ToolbarItems } from '@syncfusion/ej2-react-grids';
import { ExcelExport, ExcelExportProperties, Inject, Toolbar, Filter } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid: GridComponent | null;
const toolbar: ToolbarItems[] = ['ExcelExport'];
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'grid_excelexport') {
const excelExportProperties: ExcelExportProperties = {
enableFilter: true
};
grid.excelExport(excelExportProperties);
}
}
return (
<div>
<GridComponent id='grid' dataSource={data} allowFiltering={true}
height={270} toolbar={toolbar}
allowExcelExport={true} toolbarClick={toolbarClick} ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right' />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='150' />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='100' visible={false} />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport, Filter]} />
</GridComponent>
</div>
);
}
export default App;
export let data = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}
];
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
Define file name
The Syncfusion React Grid component allows you to specify a custom file name for the exported Excel or CSV document. This feature enables you to provide a meaningful and descriptive name for the exported file, making it easier to identify and manage the exported data.
To assign a custom file name for the exported document, you can set the fileName property of the excelExportProperties property to the desired file name.
The following example demonstrates how to define a file name using ExcelExportProperties.fileName
property when exporting to Excel, based on the entered value as the file name.
import { TextBoxComponent } from '@syncfusion/ej2-react-inputs';
import { ColumnDirective, ColumnsDirective, GridComponent } from '@syncfusion/ej2-react-grids';
import { ExcelExport, Inject, Toolbar } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid;
let textBox;
const toolbar = ['ExcelExport'];
const toolbarClick = (args) => {
if (grid && args.item.id === 'Grid_excelexport') {
const excelExportProperties = {
fileName: textBox.value !== "" ? textBox.value + '.xlsx' : 'new.xlsx'
};
grid.excelExport(excelExportProperties);
}
}
return (
<div>
<label style={{ padding: "30px 17px 0 0" }}>Enter file name: </label>
<TextBoxComponent ref={t => textBox = t} placeholder="Enter file name" width="120"></TextBoxComponent>
<GridComponent id='Grid' dataSource={data} height={270} toolbar={toolbar}
allowExcelExport={true} toolbarClick={toolbarClick} ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right' />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='150' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='150' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport]} />
</GridComponent>
</div>
);
}
export default App;
import { ClickEventArgs } from '@syncfusion/ej2-navigations';
import { TextBoxComponent } from '@syncfusion/ej2-react-inputs';
import { ColumnDirective, ColumnsDirective, GridComponent, ToolbarItems } from '@syncfusion/ej2-react-grids';
import { ExcelExport, ExcelExportProperties, Inject, Toolbar } from '@syncfusion/ej2-react-grids';
import * as React from 'react';
import { data } from './datasource';
function App() {
let grid: GridComponent | null;
let textBox: TextBoxComponent | null;
const toolbar: ToolbarItems[] = ['ExcelExport'];
const toolbarClick = (args: ClickEventArgs) => {
if (grid && args.item.id === 'Grid_excelexport') {
const excelExportProperties: ExcelExportProperties = {
fileName: (textBox as TextBoxComponent).value !== "" ? (textBox as TextBoxComponent).value + '.xlsx' : 'new.xlsx'
};
grid.excelExport(excelExportProperties);
}
}
return (
<div>
<label style={{ padding: "30px 17px 0 0" }}>Enter file name: </label>
<TextBoxComponent ref={t => textBox = t} placeholder="Enter file name" width="120"></TextBoxComponent>
<GridComponent id='Grid' dataSource={data} height={270} toolbar={toolbar}
allowExcelExport={true} toolbarClick={toolbarClick} ref={g => grid = g}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='120' textAlign='Right' />
<ColumnDirective field='CustomerID' headerText='Customer ID' width='150' />
<ColumnDirective field='ShipCity' headerText='Ship City' width='150' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
</ColumnsDirective>
<Inject services={[Toolbar, ExcelExport]} />
</GridComponent>
</div>
);
}
export default App;
export let data = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}
];
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 4, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 3, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
Export the master detail grid
The export functionality within the master-detail grid feature of the Grid enables you to export not only the master grid but also the associated detail grid onto a single Excel sheet. This feature proves to be particularly valuable when dealing with hierarchical data represented by two grids in the exported Excel file, allowing for comprehensive analysis and management.
To export the master-detail grid on the same sheet, you need to set the multipleExport.type property of the excelExportProperties object to AppendToSheet. It also has an option to provide blank space between the grids. This blank space can be defined by using multipleExport.blankRows property.
The following example demonstrates how to export master detail grid to the same page in a Excel file when a toolbar item is clicked. The rowSelected event dynamically updates the detail grid based on the selected master record:
import * as React from 'react';
import { GridComponent, ColumnsDirective, ColumnDirective, Selection, Inject, ExcelExport, Toolbar } from '@syncfusion/ej2-react-grids';
import { customerData, data } from './datasource';
function App() {
const detail = [];
let detailGrid;
let masterGrid;
const toolbarOptions = ['ExcelExport'];
const gridsToexport = ['MasterGrid', 'DetailGrid'];
const names = ['AROUT', 'BERGS', 'BLONP', 'CHOPS', 'ERNSH'];
const master = customerData.filter((e) => names.indexOf(e.CustomerID) !== -1);;
const rowselect = (args) => {
let selectedRecord = args.data;
detailGrid.dataSource = data.filter((record) => record.CustomerName === selectedRecord.ContactName).slice(0, 5);
document.getElementById('key').innerHTML = selectedRecord.ContactName;
}
const toolbarClick = (args) => {
if (args.item.id === 'MasterGrid_excelexport') {
const appendExcelExportProperties = {
multipleExport: { type: 'AppendToSheet', blankRows: 2 }
};
masterGrid.excelExport(appendExcelExportProperties, true);
}
}
return (
<div >
<p className="e-mastertext">Master Grid</p>
<GridComponent id='MasterGrid' dataSource={master} selectedRowIndex={2} ref={grid => masterGrid = grid} allowExcelExport={true}
toolbar={toolbarOptions} exportGrids={gridsToexport} rowSelected={rowselect} toolbarClick={toolbarClick}>
<ColumnsDirective>
<ColumnDirective field='ContactName' headerText='Customer Name' width='150' />
<ColumnDirective field='CompanyName' headerText='Company Name' width='150' />
<ColumnDirective field='Address' headerText='Address' width='150' />
<ColumnDirective field='Country' headerText='Country' width='150' />
</ColumnsDirective>
<Inject services={[Selection, ExcelExport, Toolbar]} />
</GridComponent>
<div className='e-statustext'> Showing orders of Customer: <b id="key"></b></div>
<GridComponent id='DetailGrid' dataSource={detail} allowExcelExport={true} allowSelection={false} ref={grid => detailGrid = grid}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='150' textAlign='Right' />
<ColumnDirective field='Freight' headerText='Freight' width='150' format='C2' textAlign='Right' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='150' />
<ColumnDirective field='ShipAddress' headerText='ShipAddress' width='150' />
</ColumnsDirective>
<Inject services={[ExcelExport, Toolbar]} />
</GridComponent>
</div>
)
}
export default App;
import * as React from 'react';
import { GridComponent, ColumnsDirective, ColumnDirective, RowSelectEventArgs, Selection, Inject, ExcelExport, Toolbar, ExcelExportProperties, ToolbarItems } from '@syncfusion/ej2-react-grids';
import { customerData, data } from './datasource';
import { ClickEventArgs } from '@syncfusion/ej2-react-navigations';
type carType = { CustomerID: string, CustomerName: string, ContactName: string };
function App() {
const detail: Object = [];
let detailGrid: GridComponent | null;
let masterGrid: GridComponent | null;
const toolbarOptions: ToolbarItems[] = ['ExcelExport'];
const gridsToexport = ['MasterGrid', 'DetailGrid'];
const names: string[] = ['AROUT', 'BERGS', 'BLONP', 'CHOPS', 'ERNSH'];
const master: Object = customerData.filter((e: any) => names.indexOf(e.CustomerID) !== -1);;
const rowselect = (args: RowSelectEventArgs) => {
let selectedRecord: carType = args.data as carType;
(detailGrid as GridComponent).dataSource = data.filter((record: any) => record.CustomerName === selectedRecord.ContactName).slice(0, 5);
(document.getElementById('key') as HTMLElement).innerHTML = selectedRecord.ContactName;
}
const toolbarClick = (args: ClickEventArgs) => {
if (args.item.id === 'MasterGrid_excelexport') {
const appendExcelExportProperties: ExcelExportProperties = {
multipleExport: { type: 'AppendToSheet', blankRows: 2 }
};
(masterGrid as GridComponent).excelExport(appendExcelExportProperties, true);
}
}
return (
<div >
<p className="e-mastertext">Master Grid</p>
<GridComponent id='MasterGrid' dataSource={master} selectedRowIndex={2} ref={grid => masterGrid = grid} allowExcelExport={true}
toolbar={toolbarOptions} exportGrids={gridsToexport} rowSelected={rowselect} toolbarClick={toolbarClick}>
<ColumnsDirective>
<ColumnDirective field='ContactName' headerText='Customer Name' width='150' />
<ColumnDirective field='CompanyName' headerText='Company Name' width='150' />
<ColumnDirective field='Address' headerText='Address' width='150' />
<ColumnDirective field='Country' headerText='Country' width='150' />
</ColumnsDirective>
<Inject services={[Selection, ExcelExport, Toolbar]} />
</GridComponent>
<div className='e-statustext'> Showing orders of Customer: <b id="key"></b></div>
<GridComponent id='DetailGrid' dataSource={detail} allowExcelExport={true} allowSelection={false} ref={grid => detailGrid = grid}>
<ColumnsDirective>
<ColumnDirective field='OrderID' headerText='Order ID' width='150' textAlign='Right' />
<ColumnDirective field='Freight' headerText='Freight' width='150' format='C2' textAlign='Right' />
<ColumnDirective field='ShipName' headerText='Ship Name' width='150' />
<ColumnDirective field='ShipCountry' headerText='Ship Country' width='150' />
<ColumnDirective field='ShipAddress' headerText='ShipAddress' width='150' />
</ColumnsDirective>
<Inject services={[ExcelExport, Toolbar]} />
</GridComponent>
</div>
)
}
export default App;
let stringData = JSON.stringify([
{
OrderID: 10248,
CustomerID: 'VINET',
OrderDate: '1996-07-04T00:00:00.000Z',
ShippedDate: '1996-07-16T00:00:00.000Z',
Freight: 32.38,
ShipName: 'Vins et alcools Chevalier',
ShipAddress: "59 rue de l'Abbaye",
ShipCity: 'Reims',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10249,
CustomerID: 'TOMSP',
OrderDate: '1996-07-05T00:00:00.000Z',
ShippedDate: '1996-07-10T00:00:00.000Z',
Freight: 11.61,
ShipName: 'Toms Spezialitäten',
ShipAddress: 'Luisenstr. 48',
ShipCity: 'Münster',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10250,
CustomerID: 'HANAR',
OrderDate: '1996-07-08T00:00:00.000Z',
ShippedDate: '1996-07-12T00:00:00.000Z',
Freight: 65.83,
ShipName: 'Hanari Carnes',
ShipAddress: 'Rua do Paço, 67',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10251,
CustomerID: 'VICTE',
OrderDate: '1996-07-08T00:00:00.000Z',
ShippedDate: '1996-07-15T00:00:00.000Z',
Freight: 41.34,
ShipName: 'Victuailles en stock',
ShipAddress: '2, rue du Commerce',
ShipCity: 'Lyon',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10252,
CustomerID: 'SUPRD',
OrderDate: '1996-07-09T00:00:00.000Z',
ShippedDate: '1996-07-11T00:00:00.000Z',
Freight: 51.3,
ShipName: 'Suprêmes délices',
ShipAddress: 'Boulevard Tirou, 255',
ShipCity: 'Charleroi',
ShipRegion: null,
ShipCountry: 'Belgium',
},
{
OrderID: 10253,
CustomerID: 'HANAR',
OrderDate: '1996-07-10T00:00:00.000Z',
ShippedDate: '1996-07-16T00:00:00.000Z',
Freight: 58.17,
ShipName: 'Hanari Carnes',
ShipAddress: 'Rua do Paço, 67',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10254,
CustomerID: 'CHOPS',
OrderDate: '1996-07-11T00:00:00.000Z',
ShippedDate: '1996-07-23T00:00:00.000Z',
Freight: 22.98,
ShipName: 'Chop-suey Chinese',
ShipAddress: 'Hauptstr. 31',
ShipCity: 'Bern',
ShipRegion: null,
ShipCountry: 'Switzerland',
},
{
OrderID: 10255,
CustomerID: 'RICSU',
OrderDate: '1996-07-12T00:00:00.000Z',
ShippedDate: '1996-07-15T00:00:00.000Z',
Freight: 148.33,
ShipName: 'Richter Supermarkt',
ShipAddress: 'Starenweg 5',
ShipCity: 'Genève',
ShipRegion: null,
ShipCountry: 'Switzerland',
},
{
OrderID: 10256,
CustomerID: 'WELLI',
OrderDate: '1996-07-15T00:00:00.000Z',
ShippedDate: '1996-07-17T00:00:00.000Z',
Freight: 13.97,
ShipName: 'Wellington Importadora',
ShipAddress: 'Rua do Mercado, 12',
ShipCity: 'Resende',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10257,
CustomerID: 'HILAA',
OrderDate: '1996-07-16T00:00:00.000Z',
ShippedDate: '1996-07-22T00:00:00.000Z',
Freight: 81.91,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10258,
CustomerID: 'ERNSH',
OrderDate: '1996-07-17T00:00:00.000Z',
ShippedDate: '1996-07-23T00:00:00.000Z',
Freight: 140.51,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10259,
CustomerID: 'CENTC',
OrderDate: '1996-07-18T00:00:00.000Z',
ShippedDate: '1996-07-25T00:00:00.000Z',
Freight: 3.25,
ShipName: 'Centro comercial Moctezuma',
ShipAddress: 'Sierras de Granada 9993',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10260,
CustomerID: 'OTTIK',
OrderDate: '1996-07-19T00:00:00.000Z',
ShippedDate: '1996-07-29T00:00:00.000Z',
Freight: 55.09,
ShipName: 'Ottilies Käseladen',
ShipAddress: 'Mehrheimerstr. 369',
ShipCity: 'Köln',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10261,
CustomerID: 'QUEDE',
OrderDate: '1996-07-19T00:00:00.000Z',
ShippedDate: '1996-07-30T00:00:00.000Z',
Freight: 3.05,
ShipName: 'Que Delícia',
ShipAddress: 'Rua da Panificadora, 12',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10262,
CustomerID: 'RATTC',
OrderDate: '1996-07-22T00:00:00.000Z',
ShippedDate: '1996-07-25T00:00:00.000Z',
Freight: 48.29,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10263,
CustomerID: 'ERNSH',
OrderDate: '1996-07-23T00:00:00.000Z',
ShippedDate: '1996-07-31T00:00:00.000Z',
Freight: 146.06,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10264,
CustomerID: 'FOLKO',
OrderDate: '1996-07-24T00:00:00.000Z',
ShippedDate: '1996-08-23T00:00:00.000Z',
Freight: 3.67,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10265,
CustomerID: 'BLONP',
OrderDate: '1996-07-25T00:00:00.000Z',
ShippedDate: '1996-08-12T00:00:00.000Z',
Freight: 55.28,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10266,
CustomerID: 'WARTH',
OrderDate: '1996-07-26T00:00:00.000Z',
ShippedDate: '1996-07-31T00:00:00.000Z',
Freight: 25.73,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10267,
CustomerID: 'FRANK',
OrderDate: '1996-07-29T00:00:00.000Z',
ShippedDate: '1996-08-06T00:00:00.000Z',
Freight: 208.58,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10268,
CustomerID: 'GROSR',
OrderDate: '1996-07-30T00:00:00.000Z',
ShippedDate: '1996-08-02T00:00:00.000Z',
Freight: 66.29,
ShipName: 'GROSELLA-Restaurante',
ShipAddress: '5ª Ave. Los Palos Grandes',
ShipCity: 'Caracas',
ShipRegion: 'DF',
ShipCountry: 'Venezuela',
},
{
OrderID: 10269,
CustomerID: 'WHITC',
OrderDate: '1996-07-31T00:00:00.000Z',
ShippedDate: '1996-08-09T00:00:00.000Z',
Freight: 4.56,
ShipName: 'White Clover Markets',
ShipAddress: '1029 - 12th Ave. S.',
ShipCity: 'Seattle',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10270,
CustomerID: 'WARTH',
OrderDate: '1996-08-01T00:00:00.000Z',
ShippedDate: '1996-08-02T00:00:00.000Z',
Freight: 136.54,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10271,
CustomerID: 'SPLIR',
OrderDate: '1996-08-01T00:00:00.000Z',
ShippedDate: '1996-08-30T00:00:00.000Z',
Freight: 4.54,
ShipName: 'Split Rail Beer & Ale',
ShipAddress: 'P.O. Box 555',
ShipCity: 'Lander',
ShipRegion: 'WY',
ShipCountry: 'USA',
},
{
OrderID: 10272,
CustomerID: 'RATTC',
OrderDate: '1996-08-02T00:00:00.000Z',
ShippedDate: '1996-08-06T00:00:00.000Z',
Freight: 98.03,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10273,
CustomerID: 'QUICK',
OrderDate: '1996-08-05T00:00:00.000Z',
ShippedDate: '1996-08-12T00:00:00.000Z',
Freight: 76.07,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10274,
CustomerID: 'VINET',
OrderDate: '1996-08-06T00:00:00.000Z',
ShippedDate: '1996-08-16T00:00:00.000Z',
Freight: 6.01,
ShipName: 'Vins et alcools Chevalier',
ShipAddress: "59 rue de l'Abbaye",
ShipCity: 'Reims',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10275,
CustomerID: 'MAGAA',
OrderDate: '1996-08-07T00:00:00.000Z',
ShippedDate: '1996-08-09T00:00:00.000Z',
Freight: 26.93,
ShipName: 'Magazzini Alimentari Riuniti',
ShipAddress: 'Via Ludovico il Moro 22',
ShipCity: 'Bergamo',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10276,
CustomerID: 'TORTU',
OrderDate: '1996-08-08T00:00:00.000Z',
ShippedDate: '1996-08-14T00:00:00.000Z',
Freight: 13.84,
ShipName: 'Tortuga Restaurante',
ShipAddress: 'Avda. Azteca 123',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10277,
CustomerID: 'MORGK',
OrderDate: '1996-08-09T00:00:00.000Z',
ShippedDate: '1996-08-13T00:00:00.000Z',
Freight: 125.77,
ShipName: 'Morgenstern Gesundkost',
ShipAddress: 'Heerstr. 22',
ShipCity: 'Leipzig',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10278,
CustomerID: 'BERGS',
OrderDate: '1996-08-12T00:00:00.000Z',
ShippedDate: '1996-08-16T00:00:00.000Z',
Freight: 92.69,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10279,
CustomerID: 'LEHMS',
OrderDate: '1996-08-13T00:00:00.000Z',
ShippedDate: '1996-08-16T00:00:00.000Z',
Freight: 25.83,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10280,
CustomerID: 'BERGS',
OrderDate: '1996-08-14T00:00:00.000Z',
ShippedDate: '1996-09-12T00:00:00.000Z',
Freight: 8.98,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10281,
CustomerID: 'ROMEY',
OrderDate: '1996-08-14T00:00:00.000Z',
ShippedDate: '1996-08-21T00:00:00.000Z',
Freight: 2.94,
ShipName: 'Romero y tomillo',
ShipAddress: 'Gran Vía, 1',
ShipCity: 'Madrid',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10282,
CustomerID: 'ROMEY',
OrderDate: '1996-08-15T00:00:00.000Z',
ShippedDate: '1996-08-21T00:00:00.000Z',
Freight: 12.69,
ShipName: 'Romero y tomillo',
ShipAddress: 'Gran Vía, 1',
ShipCity: 'Madrid',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10283,
CustomerID: 'LILAS',
OrderDate: '1996-08-16T00:00:00.000Z',
ShippedDate: '1996-08-23T00:00:00.000Z',
Freight: 84.81,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10284,
CustomerID: 'LEHMS',
OrderDate: '1996-08-19T00:00:00.000Z',
ShippedDate: '1996-08-27T00:00:00.000Z',
Freight: 76.56,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10285,
CustomerID: 'QUICK',
OrderDate: '1996-08-20T00:00:00.000Z',
ShippedDate: '1996-08-26T00:00:00.000Z',
Freight: 76.83,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10286,
CustomerID: 'QUICK',
OrderDate: '1996-08-21T00:00:00.000Z',
ShippedDate: '1996-08-30T00:00:00.000Z',
Freight: 229.24,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10287,
CustomerID: 'RICAR',
OrderDate: '1996-08-22T00:00:00.000Z',
ShippedDate: '1996-08-28T00:00:00.000Z',
Freight: 12.76,
ShipName: 'Ricardo Adocicados',
ShipAddress: 'Av. Copacabana, 267',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10288,
CustomerID: 'REGGC',
OrderDate: '1996-08-23T00:00:00.000Z',
ShippedDate: '1996-09-03T00:00:00.000Z',
Freight: 7.45,
ShipName: 'Reggiani Caseifici',
ShipAddress: 'Strada Provinciale 124',
ShipCity: 'Reggio Emilia',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10289,
CustomerID: 'BSBEV',
OrderDate: '1996-08-26T00:00:00.000Z',
ShippedDate: '1996-08-28T00:00:00.000Z',
Freight: 22.77,
ShipName: "B' Beverages",
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10290,
CustomerID: 'COMMI',
OrderDate: '1996-08-27T00:00:00.000Z',
ShippedDate: '1996-09-03T00:00:00.000Z',
Freight: 79.7,
ShipName: 'Comércio Mineiro',
ShipAddress: 'Av. dos Lusíadas, 23',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10291,
CustomerID: 'QUEDE',
OrderDate: '1996-08-27T00:00:00.000Z',
ShippedDate: '1996-09-04T00:00:00.000Z',
Freight: 6.4,
ShipName: 'Que Delícia',
ShipAddress: 'Rua da Panificadora, 12',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10292,
CustomerID: 'TRADH',
OrderDate: '1996-08-28T00:00:00.000Z',
ShippedDate: '1996-09-02T00:00:00.000Z',
Freight: 1.35,
ShipName: 'Tradiçao Hipermercados',
ShipAddress: 'Av. Inês de Castro, 414',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10293,
CustomerID: 'TORTU',
OrderDate: '1996-08-29T00:00:00.000Z',
ShippedDate: '1996-09-11T00:00:00.000Z',
Freight: 21.18,
ShipName: 'Tortuga Restaurante',
ShipAddress: 'Avda. Azteca 123',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10294,
CustomerID: 'RATTC',
OrderDate: '1996-08-30T00:00:00.000Z',
ShippedDate: '1996-09-05T00:00:00.000Z',
Freight: 147.26,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10295,
CustomerID: 'VINET',
OrderDate: '1996-09-02T00:00:00.000Z',
ShippedDate: '1996-09-10T00:00:00.000Z',
Freight: 1.15,
ShipName: 'Vins et alcools Chevalier',
ShipAddress: "59 rue de l'Abbaye",
ShipCity: 'Reims',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10296,
CustomerID: 'LILAS',
OrderDate: '1996-09-03T00:00:00.000Z',
ShippedDate: '1996-09-11T00:00:00.000Z',
Freight: 0.12,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10297,
CustomerID: 'BLONP',
OrderDate: '1996-09-04T00:00:00.000Z',
ShippedDate: '1996-09-10T00:00:00.000Z',
Freight: 5.74,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10298,
CustomerID: 'HUNGO',
OrderDate: '1996-09-05T00:00:00.000Z',
ShippedDate: '1996-09-11T00:00:00.000Z',
Freight: 168.22,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10299,
CustomerID: 'RICAR',
OrderDate: '1996-09-06T00:00:00.000Z',
ShippedDate: '1996-09-13T00:00:00.000Z',
Freight: 29.76,
ShipName: 'Ricardo Adocicados',
ShipAddress: 'Av. Copacabana, 267',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10300,
CustomerID: 'MAGAA',
OrderDate: '1996-09-09T00:00:00.000Z',
ShippedDate: '1996-09-18T00:00:00.000Z',
Freight: 17.68,
ShipName: 'Magazzini Alimentari Riuniti',
ShipAddress: 'Via Ludovico il Moro 22',
ShipCity: 'Bergamo',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10301,
CustomerID: 'WANDK',
OrderDate: '1996-09-09T00:00:00.000Z',
ShippedDate: '1996-09-17T00:00:00.000Z',
Freight: 45.08,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10302,
CustomerID: 'SUPRD',
OrderDate: '1996-09-10T00:00:00.000Z',
ShippedDate: '1996-10-09T00:00:00.000Z',
Freight: 6.27,
ShipName: 'Suprêmes délices',
ShipAddress: 'Boulevard Tirou, 255',
ShipCity: 'Charleroi',
ShipRegion: null,
ShipCountry: 'Belgium',
},
{
OrderID: 10303,
CustomerID: 'GODOS',
OrderDate: '1996-09-11T00:00:00.000Z',
ShippedDate: '1996-09-18T00:00:00.000Z',
Freight: 107.83,
ShipName: 'Godos Cocina Típica',
ShipAddress: 'C/ Romero, 33',
ShipCity: 'Sevilla',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10304,
CustomerID: 'TORTU',
OrderDate: '1996-09-12T00:00:00.000Z',
ShippedDate: '1996-09-17T00:00:00.000Z',
Freight: 63.79,
ShipName: 'Tortuga Restaurante',
ShipAddress: 'Avda. Azteca 123',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10305,
CustomerID: 'OLDWO',
OrderDate: '1996-09-13T00:00:00.000Z',
ShippedDate: '1996-10-09T00:00:00.000Z',
Freight: 257.62,
ShipName: 'Old World Delicatessen',
ShipAddress: '2743 Bering St.',
ShipCity: 'Anchorage',
ShipRegion: 'AK',
ShipCountry: 'USA',
},
{
OrderID: 10306,
CustomerID: 'ROMEY',
OrderDate: '1996-09-16T00:00:00.000Z',
ShippedDate: '1996-09-23T00:00:00.000Z',
Freight: 7.56,
ShipName: 'Romero y tomillo',
ShipAddress: 'Gran Vía, 1',
ShipCity: 'Madrid',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10307,
CustomerID: 'LONEP',
OrderDate: '1996-09-17T00:00:00.000Z',
ShippedDate: '1996-09-25T00:00:00.000Z',
Freight: 0.56,
ShipName: 'Lonesome Pine Restaurant',
ShipAddress: '89 Chiaroscuro Rd.',
ShipCity: 'Portland',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10308,
CustomerID: 'ANATR',
OrderDate: '1996-09-18T00:00:00.000Z',
ShippedDate: '1996-09-24T00:00:00.000Z',
Freight: 1.61,
ShipName: 'Ana Trujillo Emparedados y helados',
ShipAddress: 'Avda. de la Constitución 2222',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10309,
CustomerID: 'HUNGO',
OrderDate: '1996-09-19T00:00:00.000Z',
ShippedDate: '1996-10-23T00:00:00.000Z',
Freight: 47.3,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10310,
CustomerID: 'THEBI',
OrderDate: '1996-09-20T00:00:00.000Z',
ShippedDate: '1996-09-27T00:00:00.000Z',
Freight: 17.52,
ShipName: 'The Big Cheese',
ShipAddress: '89 Jefferson Way Suite 2',
ShipCity: 'Portland',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10311,
CustomerID: 'DUMON',
OrderDate: '1996-09-20T00:00:00.000Z',
ShippedDate: '1996-09-26T00:00:00.000Z',
Freight: 24.69,
ShipName: 'Du monde entier',
ShipAddress: '67, rue des Cinquante Otages',
ShipCity: 'Nantes',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10312,
CustomerID: 'WANDK',
OrderDate: '1996-09-23T00:00:00.000Z',
ShippedDate: '1996-10-03T00:00:00.000Z',
Freight: 40.26,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10313,
CustomerID: 'QUICK',
OrderDate: '1996-09-24T00:00:00.000Z',
ShippedDate: '1996-10-04T00:00:00.000Z',
Freight: 1.96,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10314,
CustomerID: 'RATTC',
OrderDate: '1996-09-25T00:00:00.000Z',
ShippedDate: '1996-10-04T00:00:00.000Z',
Freight: 74.16,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10315,
CustomerID: 'ISLAT',
OrderDate: '1996-09-26T00:00:00.000Z',
ShippedDate: '1996-10-03T00:00:00.000Z',
Freight: 41.76,
ShipName: 'Island Trading',
ShipAddress: 'Garden House Crowther Way',
ShipCity: 'Cowes',
ShipRegion: 'Isle of Wight',
ShipCountry: 'UK',
},
{
OrderID: 10316,
CustomerID: 'RATTC',
OrderDate: '1996-09-27T00:00:00.000Z',
ShippedDate: '1996-10-08T00:00:00.000Z',
Freight: 150.15,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10317,
CustomerID: 'LONEP',
OrderDate: '1996-09-30T00:00:00.000Z',
ShippedDate: '1996-10-10T00:00:00.000Z',
Freight: 12.69,
ShipName: 'Lonesome Pine Restaurant',
ShipAddress: '89 Chiaroscuro Rd.',
ShipCity: 'Portland',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10318,
CustomerID: 'ISLAT',
OrderDate: '1996-10-01T00:00:00.000Z',
ShippedDate: '1996-10-04T00:00:00.000Z',
Freight: 4.73,
ShipName: 'Island Trading',
ShipAddress: 'Garden House Crowther Way',
ShipCity: 'Cowes',
ShipRegion: 'Isle of Wight',
ShipCountry: 'UK',
},
{
OrderID: 10319,
CustomerID: 'TORTU',
OrderDate: '1996-10-02T00:00:00.000Z',
ShippedDate: '1996-10-11T00:00:00.000Z',
Freight: 64.5,
ShipName: 'Tortuga Restaurante',
ShipAddress: 'Avda. Azteca 123',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10320,
CustomerID: 'WARTH',
OrderDate: '1996-10-03T00:00:00.000Z',
ShippedDate: '1996-10-18T00:00:00.000Z',
Freight: 34.57,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10321,
CustomerID: 'ISLAT',
OrderDate: '1996-10-03T00:00:00.000Z',
ShippedDate: '1996-10-11T00:00:00.000Z',
Freight: 3.43,
ShipName: 'Island Trading',
ShipAddress: 'Garden House Crowther Way',
ShipCity: 'Cowes',
ShipRegion: 'Isle of Wight',
ShipCountry: 'UK',
},
{
OrderID: 10322,
CustomerID: 'PERIC',
OrderDate: '1996-10-04T00:00:00.000Z',
ShippedDate: '1996-10-23T00:00:00.000Z',
Freight: 0.4,
ShipName: 'Pericles Comidas clásicas',
ShipAddress: 'Calle Dr. Jorge Cash 321',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10323,
CustomerID: 'KOENE',
OrderDate: '1996-10-07T00:00:00.000Z',
ShippedDate: '1996-10-14T00:00:00.000Z',
Freight: 4.88,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10324,
CustomerID: 'SAVEA',
OrderDate: '1996-10-08T00:00:00.000Z',
ShippedDate: '1996-10-10T00:00:00.000Z',
Freight: 214.27,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10325,
CustomerID: 'KOENE',
OrderDate: '1996-10-09T00:00:00.000Z',
ShippedDate: '1996-10-14T00:00:00.000Z',
Freight: 64.86,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10326,
CustomerID: 'BOLID',
OrderDate: '1996-10-10T00:00:00.000Z',
ShippedDate: '1996-10-14T00:00:00.000Z',
Freight: 77.92,
ShipName: 'Bólido Comidas preparadas',
ShipAddress: 'C/ Araquil, 67',
ShipCity: 'Madrid',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10327,
CustomerID: 'FOLKO',
OrderDate: '1996-10-11T00:00:00.000Z',
ShippedDate: '1996-10-14T00:00:00.000Z',
Freight: 63.36,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10328,
CustomerID: 'FURIB',
OrderDate: '1996-10-14T00:00:00.000Z',
ShippedDate: '1996-10-17T00:00:00.000Z',
Freight: 87.03,
ShipName: 'Furia Bacalhau e Frutos do Mar',
ShipAddress: 'Jardim das rosas n. 32',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10329,
CustomerID: 'SPLIR',
OrderDate: '1996-10-15T00:00:00.000Z',
ShippedDate: '1996-10-23T00:00:00.000Z',
Freight: 191.67,
ShipName: 'Split Rail Beer & Ale',
ShipAddress: 'P.O. Box 555',
ShipCity: 'Lander',
ShipRegion: 'WY',
ShipCountry: 'USA',
},
{
OrderID: 10330,
CustomerID: 'LILAS',
OrderDate: '1996-10-16T00:00:00.000Z',
ShippedDate: '1996-10-28T00:00:00.000Z',
Freight: 12.75,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10331,
CustomerID: 'BONAP',
OrderDate: '1996-10-16T00:00:00.000Z',
ShippedDate: '1996-10-21T00:00:00.000Z',
Freight: 10.19,
ShipName: 'Bon app',
ShipAddress: '12, rue des Bouchers',
ShipCity: 'Marseille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10332,
CustomerID: 'MEREP',
OrderDate: '1996-10-17T00:00:00.000Z',
ShippedDate: '1996-10-21T00:00:00.000Z',
Freight: 52.84,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10333,
CustomerID: 'WARTH',
OrderDate: '1996-10-18T00:00:00.000Z',
ShippedDate: '1996-10-25T00:00:00.000Z',
Freight: 0.59,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10334,
CustomerID: 'VICTE',
OrderDate: '1996-10-21T00:00:00.000Z',
ShippedDate: '1996-10-28T00:00:00.000Z',
Freight: 8.56,
ShipName: 'Victuailles en stock',
ShipAddress: '2, rue du Commerce',
ShipCity: 'Lyon',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10335,
CustomerID: 'HUNGO',
OrderDate: '1996-10-22T00:00:00.000Z',
ShippedDate: '1996-10-24T00:00:00.000Z',
Freight: 42.11,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10336,
CustomerID: 'PRINI',
OrderDate: '1996-10-23T00:00:00.000Z',
ShippedDate: '1996-10-25T00:00:00.000Z',
Freight: 15.51,
ShipName: 'Princesa Isabel Vinhos',
ShipAddress: 'Estrada da saúde n. 58',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10337,
CustomerID: 'FRANK',
OrderDate: '1996-10-24T00:00:00.000Z',
ShippedDate: '1996-10-29T00:00:00.000Z',
Freight: 108.26,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10338,
CustomerID: 'OLDWO',
OrderDate: '1996-10-25T00:00:00.000Z',
ShippedDate: '1996-10-29T00:00:00.000Z',
Freight: 84.21,
ShipName: 'Old World Delicatessen',
ShipAddress: '2743 Bering St.',
ShipCity: 'Anchorage',
ShipRegion: 'AK',
ShipCountry: 'USA',
},
{
OrderID: 10339,
CustomerID: 'MEREP',
OrderDate: '1996-10-28T00:00:00.000Z',
ShippedDate: '1996-11-04T00:00:00.000Z',
Freight: 15.66,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10340,
CustomerID: 'BONAP',
OrderDate: '1996-10-29T00:00:00.000Z',
ShippedDate: '1996-11-08T00:00:00.000Z',
Freight: 166.31,
ShipName: 'Bon app',
ShipAddress: '12, rue des Bouchers',
ShipCity: 'Marseille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10341,
CustomerID: 'SIMOB',
OrderDate: '1996-10-29T00:00:00.000Z',
ShippedDate: '1996-11-05T00:00:00.000Z',
Freight: 26.78,
ShipName: 'Simons bistro',
ShipAddress: 'Vinbæltet 34',
ShipCity: 'Kobenhavn',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10342,
CustomerID: 'FRANK',
OrderDate: '1996-10-30T00:00:00.000Z',
ShippedDate: '1996-11-04T00:00:00.000Z',
Freight: 54.83,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10343,
CustomerID: 'LEHMS',
OrderDate: '1996-10-31T00:00:00.000Z',
ShippedDate: '1996-11-06T00:00:00.000Z',
Freight: 110.37,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10344,
CustomerID: 'WHITC',
OrderDate: '1996-11-01T00:00:00.000Z',
ShippedDate: '1996-11-05T00:00:00.000Z',
Freight: 23.29,
ShipName: 'White Clover Markets',
ShipAddress: '1029 - 12th Ave. S.',
ShipCity: 'Seattle',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10345,
CustomerID: 'QUICK',
OrderDate: '1996-11-04T00:00:00.000Z',
ShippedDate: '1996-11-11T00:00:00.000Z',
Freight: 249.06,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10346,
CustomerID: 'RATTC',
OrderDate: '1996-11-05T00:00:00.000Z',
ShippedDate: '1996-11-08T00:00:00.000Z',
Freight: 142.08,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10347,
CustomerID: 'FAMIA',
OrderDate: '1996-11-06T00:00:00.000Z',
ShippedDate: '1996-11-08T00:00:00.000Z',
Freight: 3.1,
ShipName: 'Familia Arquibaldo',
ShipAddress: 'Rua Orós, 92',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10348,
CustomerID: 'WANDK',
OrderDate: '1996-11-07T00:00:00.000Z',
ShippedDate: '1996-11-15T00:00:00.000Z',
Freight: 0.78,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10349,
CustomerID: 'SPLIR',
OrderDate: '1996-11-08T00:00:00.000Z',
ShippedDate: '1996-11-15T00:00:00.000Z',
Freight: 8.63,
ShipName: 'Split Rail Beer & Ale',
ShipAddress: 'P.O. Box 555',
ShipCity: 'Lander',
ShipRegion: 'WY',
ShipCountry: 'USA',
},
{
OrderID: 10350,
CustomerID: 'LAMAI',
OrderDate: '1996-11-11T00:00:00.000Z',
ShippedDate: '1996-12-03T00:00:00.000Z',
Freight: 64.19,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10351,
CustomerID: 'ERNSH',
OrderDate: '1996-11-11T00:00:00.000Z',
ShippedDate: '1996-11-20T00:00:00.000Z',
Freight: 162.33,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10352,
CustomerID: 'FURIB',
OrderDate: '1996-11-12T00:00:00.000Z',
ShippedDate: '1996-11-18T00:00:00.000Z',
Freight: 1.3,
ShipName: 'Furia Bacalhau e Frutos do Mar',
ShipAddress: 'Jardim das rosas n. 32',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10353,
CustomerID: 'PICCO',
OrderDate: '1996-11-13T00:00:00.000Z',
ShippedDate: '1996-11-25T00:00:00.000Z',
Freight: 360.63,
ShipName: 'Piccolo und mehr',
ShipAddress: 'Geislweg 14',
ShipCity: 'Salzburg',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10354,
CustomerID: 'PERIC',
OrderDate: '1996-11-14T00:00:00.000Z',
ShippedDate: '1996-11-20T00:00:00.000Z',
Freight: 53.8,
ShipName: 'Pericles Comidas clásicas',
ShipAddress: 'Calle Dr. Jorge Cash 321',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10355,
CustomerID: 'AROUT',
OrderDate: '1996-11-15T00:00:00.000Z',
ShippedDate: '1996-11-20T00:00:00.000Z',
Freight: 41.95,
ShipName: 'Around the Horn',
ShipAddress: 'Brook Farm Stratford St. Mary',
ShipCity: 'Colchester',
ShipRegion: 'Essex',
ShipCountry: 'UK',
},
{
OrderID: 10356,
CustomerID: 'WANDK',
OrderDate: '1996-11-18T00:00:00.000Z',
ShippedDate: '1996-11-27T00:00:00.000Z',
Freight: 36.71,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10357,
CustomerID: 'LILAS',
OrderDate: '1996-11-19T00:00:00.000Z',
ShippedDate: '1996-12-02T00:00:00.000Z',
Freight: 34.88,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10358,
CustomerID: 'LAMAI',
OrderDate: '1996-11-20T00:00:00.000Z',
ShippedDate: '1996-11-27T00:00:00.000Z',
Freight: 19.64,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10359,
CustomerID: 'SEVES',
OrderDate: '1996-11-21T00:00:00.000Z',
ShippedDate: '1996-11-26T00:00:00.000Z',
Freight: 288.43,
ShipName: 'Seven Seas Imports',
ShipAddress: '90 Wadhurst Rd.',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10360,
CustomerID: 'BLONP',
OrderDate: '1996-11-22T00:00:00.000Z',
ShippedDate: '1996-12-02T00:00:00.000Z',
Freight: 131.7,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10361,
CustomerID: 'QUICK',
OrderDate: '1996-11-22T00:00:00.000Z',
ShippedDate: '1996-12-03T00:00:00.000Z',
Freight: 183.17,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10362,
CustomerID: 'BONAP',
OrderDate: '1996-11-25T00:00:00.000Z',
ShippedDate: '1996-11-28T00:00:00.000Z',
Freight: 96.04,
ShipName: 'Bon app',
ShipAddress: '12, rue des Bouchers',
ShipCity: 'Marseille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10363,
CustomerID: 'DRACD',
OrderDate: '1996-11-26T00:00:00.000Z',
ShippedDate: '1996-12-04T00:00:00.000Z',
Freight: 30.54,
ShipName: 'Drachenblut Delikatessen',
ShipAddress: 'Walserweg 21',
ShipCity: 'Aachen',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10364,
CustomerID: 'EASTC',
OrderDate: '1996-11-26T00:00:00.000Z',
ShippedDate: '1996-12-04T00:00:00.000Z',
Freight: 71.97,
ShipName: 'Eastern Connection',
ShipAddress: '35 King George',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10365,
CustomerID: 'ANTON',
OrderDate: '1996-11-27T00:00:00.000Z',
ShippedDate: '1996-12-02T00:00:00.000Z',
Freight: 22,
ShipName: 'Antonio Moreno Taquería',
ShipAddress: 'Mataderos 2312',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10366,
CustomerID: 'GALED',
OrderDate: '1996-11-28T00:00:00.000Z',
ShippedDate: '1996-12-30T00:00:00.000Z',
Freight: 10.14,
ShipName: 'Galería del gastronómo',
ShipAddress: 'Rambla de Cataluña, 23',
ShipCity: 'Barcelona',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10367,
CustomerID: 'VAFFE',
OrderDate: '1996-11-28T00:00:00.000Z',
ShippedDate: '1996-12-02T00:00:00.000Z',
Freight: 13.55,
ShipName: 'Vaffeljernet',
ShipAddress: 'Smagsloget 45',
ShipCity: 'Århus',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10368,
CustomerID: 'ERNSH',
OrderDate: '1996-11-29T00:00:00.000Z',
ShippedDate: '1996-12-02T00:00:00.000Z',
Freight: 101.95,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10369,
CustomerID: 'SPLIR',
OrderDate: '1996-12-02T00:00:00.000Z',
ShippedDate: '1996-12-09T00:00:00.000Z',
Freight: 195.68,
ShipName: 'Split Rail Beer & Ale',
ShipAddress: 'P.O. Box 555',
ShipCity: 'Lander',
ShipRegion: 'WY',
ShipCountry: 'USA',
},
{
OrderID: 10370,
CustomerID: 'CHOPS',
OrderDate: '1996-12-03T00:00:00.000Z',
ShippedDate: '1996-12-27T00:00:00.000Z',
Freight: 1.17,
ShipName: 'Chop-suey Chinese',
ShipAddress: 'Hauptstr. 31',
ShipCity: 'Bern',
ShipRegion: null,
ShipCountry: 'Switzerland',
},
{
OrderID: 10371,
CustomerID: 'LAMAI',
OrderDate: '1996-12-03T00:00:00.000Z',
ShippedDate: '1996-12-24T00:00:00.000Z',
Freight: 0.45,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10372,
CustomerID: 'QUEEN',
OrderDate: '1996-12-04T00:00:00.000Z',
ShippedDate: '1996-12-09T00:00:00.000Z',
Freight: 890.78,
ShipName: 'Queen Cozinha',
ShipAddress: 'Alameda dos Canàrios, 891',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10373,
CustomerID: 'HUNGO',
OrderDate: '1996-12-05T00:00:00.000Z',
ShippedDate: '1996-12-11T00:00:00.000Z',
Freight: 124.12,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10374,
CustomerID: 'WOLZA',
OrderDate: '1996-12-05T00:00:00.000Z',
ShippedDate: '1996-12-09T00:00:00.000Z',
Freight: 3.94,
ShipName: 'Wolski Zajazd',
ShipAddress: 'ul. Filtrowa 68',
ShipCity: 'Warszawa',
ShipRegion: null,
ShipCountry: 'Poland',
},
{
OrderID: 10375,
CustomerID: 'HUNGC',
OrderDate: '1996-12-06T00:00:00.000Z',
ShippedDate: '1996-12-09T00:00:00.000Z',
Freight: 20.12,
ShipName: 'Hungry Coyote Import Store',
ShipAddress: 'City Center Plaza 516 Main St.',
ShipCity: 'Elgin',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10376,
CustomerID: 'MEREP',
OrderDate: '1996-12-09T00:00:00.000Z',
ShippedDate: '1996-12-13T00:00:00.000Z',
Freight: 20.39,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10377,
CustomerID: 'SEVES',
OrderDate: '1996-12-09T00:00:00.000Z',
ShippedDate: '1996-12-13T00:00:00.000Z',
Freight: 22.21,
ShipName: 'Seven Seas Imports',
ShipAddress: '90 Wadhurst Rd.',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10378,
CustomerID: 'FOLKO',
OrderDate: '1996-12-10T00:00:00.000Z',
ShippedDate: '1996-12-19T00:00:00.000Z',
Freight: 5.44,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10379,
CustomerID: 'QUEDE',
OrderDate: '1996-12-11T00:00:00.000Z',
ShippedDate: '1996-12-13T00:00:00.000Z',
Freight: 45.03,
ShipName: 'Que Delícia',
ShipAddress: 'Rua da Panificadora, 12',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10380,
CustomerID: 'HUNGO',
OrderDate: '1996-12-12T00:00:00.000Z',
ShippedDate: '1997-01-16T00:00:00.000Z',
Freight: 35.03,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10381,
CustomerID: 'LILAS',
OrderDate: '1996-12-12T00:00:00.000Z',
ShippedDate: '1996-12-13T00:00:00.000Z',
Freight: 7.99,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10382,
CustomerID: 'ERNSH',
OrderDate: '1996-12-13T00:00:00.000Z',
ShippedDate: '1996-12-16T00:00:00.000Z',
Freight: 94.77,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10383,
CustomerID: 'AROUT',
OrderDate: '1996-12-16T00:00:00.000Z',
ShippedDate: '1996-12-18T00:00:00.000Z',
Freight: 34.24,
ShipName: 'Around the Horn',
ShipAddress: 'Brook Farm Stratford St. Mary',
ShipCity: 'Colchester',
ShipRegion: 'Essex',
ShipCountry: 'UK',
},
{
OrderID: 10384,
CustomerID: 'BERGS',
OrderDate: '1996-12-16T00:00:00.000Z',
ShippedDate: '1996-12-20T00:00:00.000Z',
Freight: 168.64,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10385,
CustomerID: 'SPLIR',
OrderDate: '1996-12-17T00:00:00.000Z',
ShippedDate: '1996-12-23T00:00:00.000Z',
Freight: 30.96,
ShipName: 'Split Rail Beer & Ale',
ShipAddress: 'P.O. Box 555',
ShipCity: 'Lander',
ShipRegion: 'WY',
ShipCountry: 'USA',
},
{
OrderID: 10386,
CustomerID: 'FAMIA',
OrderDate: '1996-12-18T00:00:00.000Z',
ShippedDate: '1996-12-25T00:00:00.000Z',
Freight: 13.99,
ShipName: 'Familia Arquibaldo',
ShipAddress: 'Rua Orós, 92',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10387,
CustomerID: 'SANTG',
OrderDate: '1996-12-18T00:00:00.000Z',
ShippedDate: '1996-12-20T00:00:00.000Z',
Freight: 93.63,
ShipName: 'Santé Gourmet',
ShipAddress: 'Erling Skakkes gate 78',
ShipCity: 'Stavern',
ShipRegion: null,
ShipCountry: 'Norway',
},
{
OrderID: 10388,
CustomerID: 'SEVES',
OrderDate: '1996-12-19T00:00:00.000Z',
ShippedDate: '1996-12-20T00:00:00.000Z',
Freight: 34.86,
ShipName: 'Seven Seas Imports',
ShipAddress: '90 Wadhurst Rd.',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10389,
CustomerID: 'BOTTM',
OrderDate: '1996-12-20T00:00:00.000Z',
ShippedDate: '1996-12-24T00:00:00.000Z',
Freight: 47.42,
ShipName: 'Bottom-Dollar Markets',
ShipAddress: '23 Tsawassen Blvd.',
ShipCity: 'Tsawassen',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10390,
CustomerID: 'ERNSH',
OrderDate: '1996-12-23T00:00:00.000Z',
ShippedDate: '1996-12-26T00:00:00.000Z',
Freight: 126.38,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10391,
CustomerID: 'DRACD',
OrderDate: '1996-12-23T00:00:00.000Z',
ShippedDate: '1996-12-31T00:00:00.000Z',
Freight: 5.45,
ShipName: 'Drachenblut Delikatessen',
ShipAddress: 'Walserweg 21',
ShipCity: 'Aachen',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10392,
CustomerID: 'PICCO',
OrderDate: '1996-12-24T00:00:00.000Z',
ShippedDate: '1997-01-01T00:00:00.000Z',
Freight: 122.46,
ShipName: 'Piccolo und mehr',
ShipAddress: 'Geislweg 14',
ShipCity: 'Salzburg',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10393,
CustomerID: 'SAVEA',
OrderDate: '1996-12-25T00:00:00.000Z',
ShippedDate: '1997-01-03T00:00:00.000Z',
Freight: 126.56,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10394,
CustomerID: 'HUNGC',
OrderDate: '1996-12-25T00:00:00.000Z',
ShippedDate: '1997-01-03T00:00:00.000Z',
Freight: 30.34,
ShipName: 'Hungry Coyote Import Store',
ShipAddress: 'City Center Plaza 516 Main St.',
ShipCity: 'Elgin',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10395,
CustomerID: 'HILAA',
OrderDate: '1996-12-26T00:00:00.000Z',
ShippedDate: '1997-01-03T00:00:00.000Z',
Freight: 184.41,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10396,
CustomerID: 'FRANK',
OrderDate: '1996-12-27T00:00:00.000Z',
ShippedDate: '1997-01-06T00:00:00.000Z',
Freight: 135.35,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10397,
CustomerID: 'PRINI',
OrderDate: '1996-12-27T00:00:00.000Z',
ShippedDate: '1997-01-02T00:00:00.000Z',
Freight: 60.26,
ShipName: 'Princesa Isabel Vinhos',
ShipAddress: 'Estrada da saúde n. 58',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10398,
CustomerID: 'SAVEA',
OrderDate: '1996-12-30T00:00:00.000Z',
ShippedDate: '1997-01-09T00:00:00.000Z',
Freight: 89.16,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10399,
CustomerID: 'VAFFE',
OrderDate: '1996-12-31T00:00:00.000Z',
ShippedDate: '1997-01-08T00:00:00.000Z',
Freight: 27.36,
ShipName: 'Vaffeljernet',
ShipAddress: 'Smagsloget 45',
ShipCity: 'Århus',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10400,
CustomerID: 'EASTC',
OrderDate: '1997-01-01T00:00:00.000Z',
ShippedDate: '1997-01-16T00:00:00.000Z',
Freight: 83.93,
ShipName: 'Eastern Connection',
ShipAddress: '35 King George',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10401,
CustomerID: 'RATTC',
OrderDate: '1997-01-01T00:00:00.000Z',
ShippedDate: '1997-01-10T00:00:00.000Z',
Freight: 12.51,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10402,
CustomerID: 'ERNSH',
OrderDate: '1997-01-02T00:00:00.000Z',
ShippedDate: '1997-01-10T00:00:00.000Z',
Freight: 67.88,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10403,
CustomerID: 'ERNSH',
OrderDate: '1997-01-03T00:00:00.000Z',
ShippedDate: '1997-01-09T00:00:00.000Z',
Freight: 73.79,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10404,
CustomerID: 'MAGAA',
OrderDate: '1997-01-03T00:00:00.000Z',
ShippedDate: '1997-01-08T00:00:00.000Z',
Freight: 155.97,
ShipName: 'Magazzini Alimentari Riuniti',
ShipAddress: 'Via Ludovico il Moro 22',
ShipCity: 'Bergamo',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10405,
CustomerID: 'LINOD',
OrderDate: '1997-01-06T00:00:00.000Z',
ShippedDate: '1997-01-22T00:00:00.000Z',
Freight: 34.82,
ShipName: 'LINO-Delicateses',
ShipAddress: 'Ave. 5 de Mayo Porlamar',
ShipCity: 'I. de Margarita',
ShipRegion: 'Nueva Esparta',
ShipCountry: 'Venezuela',
},
{
OrderID: 10406,
CustomerID: 'QUEEN',
OrderDate: '1997-01-07T00:00:00.000Z',
ShippedDate: '1997-01-13T00:00:00.000Z',
Freight: 108.04,
ShipName: 'Queen Cozinha',
ShipAddress: 'Alameda dos Canàrios, 891',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10407,
CustomerID: 'OTTIK',
OrderDate: '1997-01-07T00:00:00.000Z',
ShippedDate: '1997-01-30T00:00:00.000Z',
Freight: 91.48,
ShipName: 'Ottilies Käseladen',
ShipAddress: 'Mehrheimerstr. 369',
ShipCity: 'Köln',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10408,
CustomerID: 'FOLIG',
OrderDate: '1997-01-08T00:00:00.000Z',
ShippedDate: '1997-01-14T00:00:00.000Z',
Freight: 11.26,
ShipName: 'Folies gourmandes',
ShipAddress: '184, chaussée de Tournai',
ShipCity: 'Lille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10409,
CustomerID: 'OCEAN',
OrderDate: '1997-01-09T00:00:00.000Z',
ShippedDate: '1997-01-14T00:00:00.000Z',
Freight: 29.83,
ShipName: 'Océano Atlántico Ltda.',
ShipAddress: 'Ing. Gustavo Moncada 8585 Piso 20-A',
ShipCity: 'Buenos Aires',
ShipRegion: null,
ShipCountry: 'Argentina',
},
{
OrderID: 10410,
CustomerID: 'BOTTM',
OrderDate: '1997-01-10T00:00:00.000Z',
ShippedDate: '1997-01-15T00:00:00.000Z',
Freight: 2.4,
ShipName: 'Bottom-Dollar Markets',
ShipAddress: '23 Tsawassen Blvd.',
ShipCity: 'Tsawassen',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10411,
CustomerID: 'BOTTM',
OrderDate: '1997-01-10T00:00:00.000Z',
ShippedDate: '1997-01-21T00:00:00.000Z',
Freight: 23.65,
ShipName: 'Bottom-Dollar Markets',
ShipAddress: '23 Tsawassen Blvd.',
ShipCity: 'Tsawassen',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10412,
CustomerID: 'WARTH',
OrderDate: '1997-01-13T00:00:00.000Z',
ShippedDate: '1997-01-15T00:00:00.000Z',
Freight: 3.77,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10413,
CustomerID: 'LAMAI',
OrderDate: '1997-01-14T00:00:00.000Z',
ShippedDate: '1997-01-16T00:00:00.000Z',
Freight: 95.66,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10414,
CustomerID: 'FAMIA',
OrderDate: '1997-01-14T00:00:00.000Z',
ShippedDate: '1997-01-17T00:00:00.000Z',
Freight: 21.48,
ShipName: 'Familia Arquibaldo',
ShipAddress: 'Rua Orós, 92',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10415,
CustomerID: 'HUNGC',
OrderDate: '1997-01-15T00:00:00.000Z',
ShippedDate: '1997-01-24T00:00:00.000Z',
Freight: 0.2,
ShipName: 'Hungry Coyote Import Store',
ShipAddress: 'City Center Plaza 516 Main St.',
ShipCity: 'Elgin',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10416,
CustomerID: 'WARTH',
OrderDate: '1997-01-16T00:00:00.000Z',
ShippedDate: '1997-01-27T00:00:00.000Z',
Freight: 22.72,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10417,
CustomerID: 'SIMOB',
OrderDate: '1997-01-16T00:00:00.000Z',
ShippedDate: '1997-01-28T00:00:00.000Z',
Freight: 70.29,
ShipName: 'Simons bistro',
ShipAddress: 'Vinbæltet 34',
ShipCity: 'Kobenhavn',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10418,
CustomerID: 'QUICK',
OrderDate: '1997-01-17T00:00:00.000Z',
ShippedDate: '1997-01-24T00:00:00.000Z',
Freight: 17.55,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10419,
CustomerID: 'RICSU',
OrderDate: '1997-01-20T00:00:00.000Z',
ShippedDate: '1997-01-30T00:00:00.000Z',
Freight: 137.35,
ShipName: 'Richter Supermarkt',
ShipAddress: 'Starenweg 5',
ShipCity: 'Genève',
ShipRegion: null,
ShipCountry: 'Switzerland',
},
{
OrderID: 10420,
CustomerID: 'WELLI',
OrderDate: '1997-01-21T00:00:00.000Z',
ShippedDate: '1997-01-27T00:00:00.000Z',
Freight: 44.12,
ShipName: 'Wellington Importadora',
ShipAddress: 'Rua do Mercado, 12',
ShipCity: 'Resende',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10421,
CustomerID: 'QUEDE',
OrderDate: '1997-01-21T00:00:00.000Z',
ShippedDate: '1997-01-27T00:00:00.000Z',
Freight: 99.23,
ShipName: 'Que Delícia',
ShipAddress: 'Rua da Panificadora, 12',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10422,
CustomerID: 'FRANS',
OrderDate: '1997-01-22T00:00:00.000Z',
ShippedDate: '1997-01-31T00:00:00.000Z',
Freight: 3.02,
ShipName: 'Franchi S.p.A.',
ShipAddress: 'Via Monte Bianco 34',
ShipCity: 'Torino',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10423,
CustomerID: 'GOURL',
OrderDate: '1997-01-23T00:00:00.000Z',
ShippedDate: '1997-02-24T00:00:00.000Z',
Freight: 24.5,
ShipName: 'Gourmet Lanchonetes',
ShipAddress: 'Av. Brasil, 442',
ShipCity: 'Campinas',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10424,
CustomerID: 'MEREP',
OrderDate: '1997-01-23T00:00:00.000Z',
ShippedDate: '1997-01-27T00:00:00.000Z',
Freight: 370.61,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10425,
CustomerID: 'LAMAI',
OrderDate: '1997-01-24T00:00:00.000Z',
ShippedDate: '1997-02-14T00:00:00.000Z',
Freight: 7.93,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10426,
CustomerID: 'GALED',
OrderDate: '1997-01-27T00:00:00.000Z',
ShippedDate: '1997-02-06T00:00:00.000Z',
Freight: 18.69,
ShipName: 'Galería del gastronómo',
ShipAddress: 'Rambla de Cataluña, 23',
ShipCity: 'Barcelona',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10427,
CustomerID: 'PICCO',
OrderDate: '1997-01-27T00:00:00.000Z',
ShippedDate: '1997-03-03T00:00:00.000Z',
Freight: 31.29,
ShipName: 'Piccolo und mehr',
ShipAddress: 'Geislweg 14',
ShipCity: 'Salzburg',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10428,
CustomerID: 'REGGC',
OrderDate: '1997-01-28T00:00:00.000Z',
ShippedDate: '1997-02-04T00:00:00.000Z',
Freight: 11.09,
ShipName: 'Reggiani Caseifici',
ShipAddress: 'Strada Provinciale 124',
ShipCity: 'Reggio Emilia',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10429,
CustomerID: 'HUNGO',
OrderDate: '1997-01-29T00:00:00.000Z',
ShippedDate: '1997-02-07T00:00:00.000Z',
Freight: 56.63,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10430,
CustomerID: 'ERNSH',
OrderDate: '1997-01-30T00:00:00.000Z',
ShippedDate: '1997-02-03T00:00:00.000Z',
Freight: 458.78,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10431,
CustomerID: 'BOTTM',
OrderDate: '1997-01-30T00:00:00.000Z',
ShippedDate: '1997-02-07T00:00:00.000Z',
Freight: 44.17,
ShipName: 'Bottom-Dollar Markets',
ShipAddress: '23 Tsawassen Blvd.',
ShipCity: 'Tsawassen',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10432,
CustomerID: 'SPLIR',
OrderDate: '1997-01-31T00:00:00.000Z',
ShippedDate: '1997-02-07T00:00:00.000Z',
Freight: 4.34,
ShipName: 'Split Rail Beer & Ale',
ShipAddress: 'P.O. Box 555',
ShipCity: 'Lander',
ShipRegion: 'WY',
ShipCountry: 'USA',
},
{
OrderID: 10433,
CustomerID: 'PRINI',
OrderDate: '1997-02-03T00:00:00.000Z',
ShippedDate: '1997-03-04T00:00:00.000Z',
Freight: 73.83,
ShipName: 'Princesa Isabel Vinhos',
ShipAddress: 'Estrada da saúde n. 58',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10434,
CustomerID: 'FOLKO',
OrderDate: '1997-02-03T00:00:00.000Z',
ShippedDate: '1997-02-13T00:00:00.000Z',
Freight: 17.92,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10435,
CustomerID: 'CONSH',
OrderDate: '1997-02-04T00:00:00.000Z',
ShippedDate: '1997-02-07T00:00:00.000Z',
Freight: 9.21,
ShipName: 'Consolidated Holdings',
ShipAddress: 'Berkeley Gardens 12 Brewery',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10436,
CustomerID: 'BLONP',
OrderDate: '1997-02-05T00:00:00.000Z',
ShippedDate: '1997-02-11T00:00:00.000Z',
Freight: 156.66,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10437,
CustomerID: 'WARTH',
OrderDate: '1997-02-05T00:00:00.000Z',
ShippedDate: '1997-02-12T00:00:00.000Z',
Freight: 19.97,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10438,
CustomerID: 'TOMSP',
OrderDate: '1997-02-06T00:00:00.000Z',
ShippedDate: '1997-02-14T00:00:00.000Z',
Freight: 8.24,
ShipName: 'Toms Spezialitäten',
ShipAddress: 'Luisenstr. 48',
ShipCity: 'Münster',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10439,
CustomerID: 'MEREP',
OrderDate: '1997-02-07T00:00:00.000Z',
ShippedDate: '1997-02-10T00:00:00.000Z',
Freight: 4.07,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10440,
CustomerID: 'SAVEA',
OrderDate: '1997-02-10T00:00:00.000Z',
ShippedDate: '1997-02-28T00:00:00.000Z',
Freight: 86.53,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10441,
CustomerID: 'OLDWO',
OrderDate: '1997-02-10T00:00:00.000Z',
ShippedDate: '1997-03-14T00:00:00.000Z',
Freight: 73.02,
ShipName: 'Old World Delicatessen',
ShipAddress: '2743 Bering St.',
ShipCity: 'Anchorage',
ShipRegion: 'AK',
ShipCountry: 'USA',
},
{
OrderID: 10442,
CustomerID: 'ERNSH',
OrderDate: '1997-02-11T00:00:00.000Z',
ShippedDate: '1997-02-18T00:00:00.000Z',
Freight: 47.94,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10443,
CustomerID: 'REGGC',
OrderDate: '1997-02-12T00:00:00.000Z',
ShippedDate: '1997-02-14T00:00:00.000Z',
Freight: 13.95,
ShipName: 'Reggiani Caseifici',
ShipAddress: 'Strada Provinciale 124',
ShipCity: 'Reggio Emilia',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10444,
CustomerID: 'BERGS',
OrderDate: '1997-02-12T00:00:00.000Z',
ShippedDate: '1997-02-21T00:00:00.000Z',
Freight: 3.5,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10445,
CustomerID: 'BERGS',
OrderDate: '1997-02-13T00:00:00.000Z',
ShippedDate: '1997-02-20T00:00:00.000Z',
Freight: 9.3,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10446,
CustomerID: 'TOMSP',
OrderDate: '1997-02-14T00:00:00.000Z',
ShippedDate: '1997-02-19T00:00:00.000Z',
Freight: 14.68,
ShipName: 'Toms Spezialitäten',
ShipAddress: 'Luisenstr. 48',
ShipCity: 'Münster',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10447,
CustomerID: 'RICAR',
OrderDate: '1997-02-14T00:00:00.000Z',
ShippedDate: '1997-03-07T00:00:00.000Z',
Freight: 68.66,
ShipName: 'Ricardo Adocicados',
ShipAddress: 'Av. Copacabana, 267',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10448,
CustomerID: 'RANCH',
OrderDate: '1997-02-17T00:00:00.000Z',
ShippedDate: '1997-02-24T00:00:00.000Z',
Freight: 38.82,
ShipName: 'Rancho grande',
ShipAddress: 'Av. del Libertador 900',
ShipCity: 'Buenos Aires',
ShipRegion: null,
ShipCountry: 'Argentina',
},
{
OrderID: 10449,
CustomerID: 'BLONP',
OrderDate: '1997-02-18T00:00:00.000Z',
ShippedDate: '1997-02-27T00:00:00.000Z',
Freight: 53.3,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10450,
CustomerID: 'VICTE',
OrderDate: '1997-02-19T00:00:00.000Z',
ShippedDate: '1997-03-11T00:00:00.000Z',
Freight: 7.23,
ShipName: 'Victuailles en stock',
ShipAddress: '2, rue du Commerce',
ShipCity: 'Lyon',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10451,
CustomerID: 'QUICK',
OrderDate: '1997-02-19T00:00:00.000Z',
ShippedDate: '1997-03-12T00:00:00.000Z',
Freight: 189.09,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10452,
CustomerID: 'SAVEA',
OrderDate: '1997-02-20T00:00:00.000Z',
ShippedDate: '1997-02-26T00:00:00.000Z',
Freight: 140.26,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10453,
CustomerID: 'AROUT',
OrderDate: '1997-02-21T00:00:00.000Z',
ShippedDate: '1997-02-26T00:00:00.000Z',
Freight: 25.36,
ShipName: 'Around the Horn',
ShipAddress: 'Brook Farm Stratford St. Mary',
ShipCity: 'Colchester',
ShipRegion: 'Essex',
ShipCountry: 'UK',
},
{
OrderID: 10454,
CustomerID: 'LAMAI',
OrderDate: '1997-02-21T00:00:00.000Z',
ShippedDate: '1997-02-25T00:00:00.000Z',
Freight: 2.74,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10455,
CustomerID: 'WARTH',
OrderDate: '1997-02-24T00:00:00.000Z',
ShippedDate: '1997-03-03T00:00:00.000Z',
Freight: 180.45,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10456,
CustomerID: 'KOENE',
OrderDate: '1997-02-25T00:00:00.000Z',
ShippedDate: '1997-02-28T00:00:00.000Z',
Freight: 8.12,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10457,
CustomerID: 'KOENE',
OrderDate: '1997-02-25T00:00:00.000Z',
ShippedDate: '1997-03-03T00:00:00.000Z',
Freight: 11.57,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10458,
CustomerID: 'SUPRD',
OrderDate: '1997-02-26T00:00:00.000Z',
ShippedDate: '1997-03-04T00:00:00.000Z',
Freight: 147.06,
ShipName: 'Suprêmes délices',
ShipAddress: 'Boulevard Tirou, 255',
ShipCity: 'Charleroi',
ShipRegion: null,
ShipCountry: 'Belgium',
},
{
OrderID: 10459,
CustomerID: 'VICTE',
OrderDate: '1997-02-27T00:00:00.000Z',
ShippedDate: '1997-02-28T00:00:00.000Z',
Freight: 25.09,
ShipName: 'Victuailles en stock',
ShipAddress: '2, rue du Commerce',
ShipCity: 'Lyon',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10460,
CustomerID: 'FOLKO',
OrderDate: '1997-02-28T00:00:00.000Z',
ShippedDate: '1997-03-03T00:00:00.000Z',
Freight: 16.27,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10461,
CustomerID: 'LILAS',
OrderDate: '1997-02-28T00:00:00.000Z',
ShippedDate: '1997-03-05T00:00:00.000Z',
Freight: 148.61,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10462,
CustomerID: 'CONSH',
OrderDate: '1997-03-03T00:00:00.000Z',
ShippedDate: '1997-03-18T00:00:00.000Z',
Freight: 6.17,
ShipName: 'Consolidated Holdings',
ShipAddress: 'Berkeley Gardens 12 Brewery',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10463,
CustomerID: 'SUPRD',
OrderDate: '1997-03-04T00:00:00.000Z',
ShippedDate: '1997-03-06T00:00:00.000Z',
Freight: 14.78,
ShipName: 'Suprêmes délices',
ShipAddress: 'Boulevard Tirou, 255',
ShipCity: 'Charleroi',
ShipRegion: null,
ShipCountry: 'Belgium',
},
{
OrderID: 10464,
CustomerID: 'FURIB',
OrderDate: '1997-03-04T00:00:00.000Z',
ShippedDate: '1997-03-14T00:00:00.000Z',
Freight: 89,
ShipName: 'Furia Bacalhau e Frutos do Mar',
ShipAddress: 'Jardim das rosas n. 32',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10465,
CustomerID: 'VAFFE',
OrderDate: '1997-03-05T00:00:00.000Z',
ShippedDate: '1997-03-14T00:00:00.000Z',
Freight: 145.04,
ShipName: 'Vaffeljernet',
ShipAddress: 'Smagsloget 45',
ShipCity: 'Århus',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10466,
CustomerID: 'COMMI',
OrderDate: '1997-03-06T00:00:00.000Z',
ShippedDate: '1997-03-13T00:00:00.000Z',
Freight: 11.93,
ShipName: 'Comércio Mineiro',
ShipAddress: 'Av. dos Lusíadas, 23',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10467,
CustomerID: 'MAGAA',
OrderDate: '1997-03-06T00:00:00.000Z',
ShippedDate: '1997-03-11T00:00:00.000Z',
Freight: 4.93,
ShipName: 'Magazzini Alimentari Riuniti',
ShipAddress: 'Via Ludovico il Moro 22',
ShipCity: 'Bergamo',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10468,
CustomerID: 'KOENE',
OrderDate: '1997-03-07T00:00:00.000Z',
ShippedDate: '1997-03-12T00:00:00.000Z',
Freight: 44.12,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10469,
CustomerID: 'WHITC',
OrderDate: '1997-03-10T00:00:00.000Z',
ShippedDate: '1997-03-14T00:00:00.000Z',
Freight: 60.18,
ShipName: 'White Clover Markets',
ShipAddress: '1029 - 12th Ave. S.',
ShipCity: 'Seattle',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10470,
CustomerID: 'BONAP',
OrderDate: '1997-03-11T00:00:00.000Z',
ShippedDate: '1997-03-14T00:00:00.000Z',
Freight: 64.56,
ShipName: 'Bon app',
ShipAddress: '12, rue des Bouchers',
ShipCity: 'Marseille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10471,
CustomerID: 'BSBEV',
OrderDate: '1997-03-11T00:00:00.000Z',
ShippedDate: '1997-03-18T00:00:00.000Z',
Freight: 45.59,
ShipName: "B' Beverages",
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10472,
CustomerID: 'SEVES',
OrderDate: '1997-03-12T00:00:00.000Z',
ShippedDate: '1997-03-19T00:00:00.000Z',
Freight: 4.2,
ShipName: 'Seven Seas Imports',
ShipAddress: '90 Wadhurst Rd.',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10473,
CustomerID: 'ISLAT',
OrderDate: '1997-03-13T00:00:00.000Z',
ShippedDate: '1997-03-21T00:00:00.000Z',
Freight: 16.37,
ShipName: 'Island Trading',
ShipAddress: 'Garden House Crowther Way',
ShipCity: 'Cowes',
ShipRegion: 'Isle of Wight',
ShipCountry: 'UK',
},
{
OrderID: 10474,
CustomerID: 'PERIC',
OrderDate: '1997-03-13T00:00:00.000Z',
ShippedDate: '1997-03-21T00:00:00.000Z',
Freight: 83.49,
ShipName: 'Pericles Comidas clásicas',
ShipAddress: 'Calle Dr. Jorge Cash 321',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10475,
CustomerID: 'SUPRD',
OrderDate: '1997-03-14T00:00:00.000Z',
ShippedDate: '1997-04-04T00:00:00.000Z',
Freight: 68.52,
ShipName: 'Suprêmes délices',
ShipAddress: 'Boulevard Tirou, 255',
ShipCity: 'Charleroi',
ShipRegion: null,
ShipCountry: 'Belgium',
},
{
OrderID: 10476,
CustomerID: 'HILAA',
OrderDate: '1997-03-17T00:00:00.000Z',
ShippedDate: '1997-03-24T00:00:00.000Z',
Freight: 4.41,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10477,
CustomerID: 'PRINI',
OrderDate: '1997-03-17T00:00:00.000Z',
ShippedDate: '1997-03-25T00:00:00.000Z',
Freight: 13.02,
ShipName: 'Princesa Isabel Vinhos',
ShipAddress: 'Estrada da saúde n. 58',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10478,
CustomerID: 'VICTE',
OrderDate: '1997-03-18T00:00:00.000Z',
ShippedDate: '1997-03-26T00:00:00.000Z',
Freight: 4.81,
ShipName: 'Victuailles en stock',
ShipAddress: '2, rue du Commerce',
ShipCity: 'Lyon',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10479,
CustomerID: 'RATTC',
OrderDate: '1997-03-19T00:00:00.000Z',
ShippedDate: '1997-03-21T00:00:00.000Z',
Freight: 708.95,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10480,
CustomerID: 'FOLIG',
OrderDate: '1997-03-20T00:00:00.000Z',
ShippedDate: '1997-03-24T00:00:00.000Z',
Freight: 1.35,
ShipName: 'Folies gourmandes',
ShipAddress: '184, chaussée de Tournai',
ShipCity: 'Lille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10481,
CustomerID: 'RICAR',
OrderDate: '1997-03-20T00:00:00.000Z',
ShippedDate: '1997-03-25T00:00:00.000Z',
Freight: 64.33,
ShipName: 'Ricardo Adocicados',
ShipAddress: 'Av. Copacabana, 267',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10482,
CustomerID: 'LAZYK',
OrderDate: '1997-03-21T00:00:00.000Z',
ShippedDate: '1997-04-10T00:00:00.000Z',
Freight: 7.48,
ShipName: 'Lazy K Kountry Store',
ShipAddress: '12 Orchestra Terrace',
ShipCity: 'Walla Walla',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10483,
CustomerID: 'WHITC',
OrderDate: '1997-03-24T00:00:00.000Z',
ShippedDate: '1997-04-25T00:00:00.000Z',
Freight: 15.28,
ShipName: 'White Clover Markets',
ShipAddress: '1029 - 12th Ave. S.',
ShipCity: 'Seattle',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10484,
CustomerID: 'BSBEV',
OrderDate: '1997-03-24T00:00:00.000Z',
ShippedDate: '1997-04-01T00:00:00.000Z',
Freight: 6.88,
ShipName: "B' Beverages",
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10485,
CustomerID: 'LINOD',
OrderDate: '1997-03-25T00:00:00.000Z',
ShippedDate: '1997-03-31T00:00:00.000Z',
Freight: 64.45,
ShipName: 'LINO-Delicateses',
ShipAddress: 'Ave. 5 de Mayo Porlamar',
ShipCity: 'I. de Margarita',
ShipRegion: 'Nueva Esparta',
ShipCountry: 'Venezuela',
},
{
OrderID: 10486,
CustomerID: 'HILAA',
OrderDate: '1997-03-26T00:00:00.000Z',
ShippedDate: '1997-04-02T00:00:00.000Z',
Freight: 30.53,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10487,
CustomerID: 'QUEEN',
OrderDate: '1997-03-26T00:00:00.000Z',
ShippedDate: '1997-03-28T00:00:00.000Z',
Freight: 71.07,
ShipName: 'Queen Cozinha',
ShipAddress: 'Alameda dos Canàrios, 891',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10488,
CustomerID: 'FRANK',
OrderDate: '1997-03-27T00:00:00.000Z',
ShippedDate: '1997-04-02T00:00:00.000Z',
Freight: 4.93,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10489,
CustomerID: 'PICCO',
OrderDate: '1997-03-28T00:00:00.000Z',
ShippedDate: '1997-04-09T00:00:00.000Z',
Freight: 5.29,
ShipName: 'Piccolo und mehr',
ShipAddress: 'Geislweg 14',
ShipCity: 'Salzburg',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10490,
CustomerID: 'HILAA',
OrderDate: '1997-03-31T00:00:00.000Z',
ShippedDate: '1997-04-03T00:00:00.000Z',
Freight: 210.19,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10491,
CustomerID: 'FURIB',
OrderDate: '1997-03-31T00:00:00.000Z',
ShippedDate: '1997-04-08T00:00:00.000Z',
Freight: 16.96,
ShipName: 'Furia Bacalhau e Frutos do Mar',
ShipAddress: 'Jardim das rosas n. 32',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10492,
CustomerID: 'BOTTM',
OrderDate: '1997-04-01T00:00:00.000Z',
ShippedDate: '1997-04-11T00:00:00.000Z',
Freight: 62.89,
ShipName: 'Bottom-Dollar Markets',
ShipAddress: '23 Tsawassen Blvd.',
ShipCity: 'Tsawassen',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10493,
CustomerID: 'LAMAI',
OrderDate: '1997-04-02T00:00:00.000Z',
ShippedDate: '1997-04-10T00:00:00.000Z',
Freight: 10.64,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10494,
CustomerID: 'COMMI',
OrderDate: '1997-04-02T00:00:00.000Z',
ShippedDate: '1997-04-09T00:00:00.000Z',
Freight: 65.99,
ShipName: 'Comércio Mineiro',
ShipAddress: 'Av. dos Lusíadas, 23',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10495,
CustomerID: 'LAUGB',
OrderDate: '1997-04-03T00:00:00.000Z',
ShippedDate: '1997-04-11T00:00:00.000Z',
Freight: 4.65,
ShipName: 'Laughing Bacchus Wine Cellars',
ShipAddress: '2319 Elm St.',
ShipCity: 'Vancouver',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10496,
CustomerID: 'TRADH',
OrderDate: '1997-04-04T00:00:00.000Z',
ShippedDate: '1997-04-07T00:00:00.000Z',
Freight: 46.77,
ShipName: 'Tradiçao Hipermercados',
ShipAddress: 'Av. Inês de Castro, 414',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10497,
CustomerID: 'LEHMS',
OrderDate: '1997-04-04T00:00:00.000Z',
ShippedDate: '1997-04-07T00:00:00.000Z',
Freight: 36.21,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10498,
CustomerID: 'HILAA',
OrderDate: '1997-04-07T00:00:00.000Z',
ShippedDate: '1997-04-11T00:00:00.000Z',
Freight: 29.75,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10499,
CustomerID: 'LILAS',
OrderDate: '1997-04-08T00:00:00.000Z',
ShippedDate: '1997-04-16T00:00:00.000Z',
Freight: 102.02,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10500,
CustomerID: 'LAMAI',
OrderDate: '1997-04-09T00:00:00.000Z',
ShippedDate: '1997-04-17T00:00:00.000Z',
Freight: 42.68,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10501,
CustomerID: 'BLAUS',
OrderDate: '1997-04-09T00:00:00.000Z',
ShippedDate: '1997-04-16T00:00:00.000Z',
Freight: 8.85,
ShipName: 'Blauer See Delikatessen',
ShipAddress: 'Forsterstr. 57',
ShipCity: 'Mannheim',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10502,
CustomerID: 'PERIC',
OrderDate: '1997-04-10T00:00:00.000Z',
ShippedDate: '1997-04-29T00:00:00.000Z',
Freight: 69.32,
ShipName: 'Pericles Comidas clásicas',
ShipAddress: 'Calle Dr. Jorge Cash 321',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10503,
CustomerID: 'HUNGO',
OrderDate: '1997-04-11T00:00:00.000Z',
ShippedDate: '1997-04-16T00:00:00.000Z',
Freight: 16.74,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10504,
CustomerID: 'WHITC',
OrderDate: '1997-04-11T00:00:00.000Z',
ShippedDate: '1997-04-18T00:00:00.000Z',
Freight: 59.13,
ShipName: 'White Clover Markets',
ShipAddress: '1029 - 12th Ave. S.',
ShipCity: 'Seattle',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10505,
CustomerID: 'MEREP',
OrderDate: '1997-04-14T00:00:00.000Z',
ShippedDate: '1997-04-21T00:00:00.000Z',
Freight: 7.13,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10506,
CustomerID: 'KOENE',
OrderDate: '1997-04-15T00:00:00.000Z',
ShippedDate: '1997-05-02T00:00:00.000Z',
Freight: 21.19,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10507,
CustomerID: 'ANTON',
OrderDate: '1997-04-15T00:00:00.000Z',
ShippedDate: '1997-04-22T00:00:00.000Z',
Freight: 47.45,
ShipName: 'Antonio Moreno Taquería',
ShipAddress: 'Mataderos 2312',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10508,
CustomerID: 'OTTIK',
OrderDate: '1997-04-16T00:00:00.000Z',
ShippedDate: '1997-05-13T00:00:00.000Z',
Freight: 4.99,
ShipName: 'Ottilies Käseladen',
ShipAddress: 'Mehrheimerstr. 369',
ShipCity: 'Köln',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10509,
CustomerID: 'BLAUS',
OrderDate: '1997-04-17T00:00:00.000Z',
ShippedDate: '1997-04-29T00:00:00.000Z',
Freight: 0.15,
ShipName: 'Blauer See Delikatessen',
ShipAddress: 'Forsterstr. 57',
ShipCity: 'Mannheim',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10510,
CustomerID: 'SAVEA',
OrderDate: '1997-04-18T00:00:00.000Z',
ShippedDate: '1997-04-28T00:00:00.000Z',
Freight: 367.63,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10511,
CustomerID: 'BONAP',
OrderDate: '1997-04-18T00:00:00.000Z',
ShippedDate: '1997-04-21T00:00:00.000Z',
Freight: 350.64,
ShipName: 'Bon app',
ShipAddress: '12, rue des Bouchers',
ShipCity: 'Marseille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10512,
CustomerID: 'FAMIA',
OrderDate: '1997-04-21T00:00:00.000Z',
ShippedDate: '1997-04-24T00:00:00.000Z',
Freight: 3.53,
ShipName: 'Familia Arquibaldo',
ShipAddress: 'Rua Orós, 92',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10513,
CustomerID: 'WANDK',
OrderDate: '1997-04-22T00:00:00.000Z',
ShippedDate: '1997-04-28T00:00:00.000Z',
Freight: 105.65,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10514,
CustomerID: 'ERNSH',
OrderDate: '1997-04-22T00:00:00.000Z',
ShippedDate: '1997-05-16T00:00:00.000Z',
Freight: 789.95,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10515,
CustomerID: 'QUICK',
OrderDate: '1997-04-23T00:00:00.000Z',
ShippedDate: '1997-05-23T00:00:00.000Z',
Freight: 204.47,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10516,
CustomerID: 'HUNGO',
OrderDate: '1997-04-24T00:00:00.000Z',
ShippedDate: '1997-05-01T00:00:00.000Z',
Freight: 62.78,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10517,
CustomerID: 'NORTS',
OrderDate: '1997-04-24T00:00:00.000Z',
ShippedDate: '1997-04-29T00:00:00.000Z',
Freight: 32.07,
ShipName: 'North/South',
ShipAddress: 'South House 300 Queensbridge',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10518,
CustomerID: 'TORTU',
OrderDate: '1997-04-25T00:00:00.000Z',
ShippedDate: '1997-05-05T00:00:00.000Z',
Freight: 218.15,
ShipName: 'Tortuga Restaurante',
ShipAddress: 'Avda. Azteca 123',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10519,
CustomerID: 'CHOPS',
OrderDate: '1997-04-28T00:00:00.000Z',
ShippedDate: '1997-05-01T00:00:00.000Z',
Freight: 91.76,
ShipName: 'Chop-suey Chinese',
ShipAddress: 'Hauptstr. 31',
ShipCity: 'Bern',
ShipRegion: null,
ShipCountry: 'Switzerland',
},
{
OrderID: 10520,
CustomerID: 'SANTG',
OrderDate: '1997-04-29T00:00:00.000Z',
ShippedDate: '1997-05-01T00:00:00.000Z',
Freight: 13.37,
ShipName: 'Santé Gourmet',
ShipAddress: 'Erling Skakkes gate 78',
ShipCity: 'Stavern',
ShipRegion: null,
ShipCountry: 'Norway',
},
{
OrderID: 10521,
CustomerID: 'CACTU',
OrderDate: '1997-04-29T00:00:00.000Z',
ShippedDate: '1997-05-02T00:00:00.000Z',
Freight: 17.22,
ShipName: 'Cactus Comidas para llevar',
ShipAddress: 'Cerrito 333',
ShipCity: 'Buenos Aires',
ShipRegion: null,
ShipCountry: 'Argentina',
},
{
OrderID: 10522,
CustomerID: 'LEHMS',
OrderDate: '1997-04-30T00:00:00.000Z',
ShippedDate: '1997-05-06T00:00:00.000Z',
Freight: 45.33,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10523,
CustomerID: 'SEVES',
OrderDate: '1997-05-01T00:00:00.000Z',
ShippedDate: '1997-05-30T00:00:00.000Z',
Freight: 77.63,
ShipName: 'Seven Seas Imports',
ShipAddress: '90 Wadhurst Rd.',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10524,
CustomerID: 'BERGS',
OrderDate: '1997-05-01T00:00:00.000Z',
ShippedDate: '1997-05-07T00:00:00.000Z',
Freight: 244.79,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10525,
CustomerID: 'BONAP',
OrderDate: '1997-05-02T00:00:00.000Z',
ShippedDate: '1997-05-23T00:00:00.000Z',
Freight: 11.06,
ShipName: 'Bon app',
ShipAddress: '12, rue des Bouchers',
ShipCity: 'Marseille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10526,
CustomerID: 'WARTH',
OrderDate: '1997-05-05T00:00:00.000Z',
ShippedDate: '1997-05-15T00:00:00.000Z',
Freight: 58.59,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10527,
CustomerID: 'QUICK',
OrderDate: '1997-05-05T00:00:00.000Z',
ShippedDate: '1997-05-07T00:00:00.000Z',
Freight: 41.9,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10528,
CustomerID: 'GREAL',
OrderDate: '1997-05-06T00:00:00.000Z',
ShippedDate: '1997-05-09T00:00:00.000Z',
Freight: 3.35,
ShipName: 'Great Lakes Food Market',
ShipAddress: '2732 Baker Blvd.',
ShipCity: 'Eugene',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10529,
CustomerID: 'MAISD',
OrderDate: '1997-05-07T00:00:00.000Z',
ShippedDate: '1997-05-09T00:00:00.000Z',
Freight: 66.69,
ShipName: 'Maison Dewey',
ShipAddress: 'Rue Joseph-Bens 532',
ShipCity: 'Bruxelles',
ShipRegion: null,
ShipCountry: 'Belgium',
},
{
OrderID: 10530,
CustomerID: 'PICCO',
OrderDate: '1997-05-08T00:00:00.000Z',
ShippedDate: '1997-05-12T00:00:00.000Z',
Freight: 339.22,
ShipName: 'Piccolo und mehr',
ShipAddress: 'Geislweg 14',
ShipCity: 'Salzburg',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10531,
CustomerID: 'OCEAN',
OrderDate: '1997-05-08T00:00:00.000Z',
ShippedDate: '1997-05-19T00:00:00.000Z',
Freight: 8.12,
ShipName: 'Océano Atlántico Ltda.',
ShipAddress: 'Ing. Gustavo Moncada 8585 Piso 20-A',
ShipCity: 'Buenos Aires',
ShipRegion: null,
ShipCountry: 'Argentina',
},
{
OrderID: 10532,
CustomerID: 'EASTC',
OrderDate: '1997-05-09T00:00:00.000Z',
ShippedDate: '1997-05-12T00:00:00.000Z',
Freight: 74.46,
ShipName: 'Eastern Connection',
ShipAddress: '35 King George',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10533,
CustomerID: 'FOLKO',
OrderDate: '1997-05-12T00:00:00.000Z',
ShippedDate: '1997-05-22T00:00:00.000Z',
Freight: 188.04,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10534,
CustomerID: 'LEHMS',
OrderDate: '1997-05-12T00:00:00.000Z',
ShippedDate: '1997-05-14T00:00:00.000Z',
Freight: 27.94,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10535,
CustomerID: 'ANTON',
OrderDate: '1997-05-13T00:00:00.000Z',
ShippedDate: '1997-05-21T00:00:00.000Z',
Freight: 15.64,
ShipName: 'Antonio Moreno Taquería',
ShipAddress: 'Mataderos 2312',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10536,
CustomerID: 'LEHMS',
OrderDate: '1997-05-14T00:00:00.000Z',
ShippedDate: '1997-06-06T00:00:00.000Z',
Freight: 58.88,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10537,
CustomerID: 'RICSU',
OrderDate: '1997-05-14T00:00:00.000Z',
ShippedDate: '1997-05-19T00:00:00.000Z',
Freight: 78.85,
ShipName: 'Richter Supermarkt',
ShipAddress: 'Starenweg 5',
ShipCity: 'Genève',
ShipRegion: null,
ShipCountry: 'Switzerland',
},
{
OrderID: 10538,
CustomerID: 'BSBEV',
OrderDate: '1997-05-15T00:00:00.000Z',
ShippedDate: '1997-05-16T00:00:00.000Z',
Freight: 4.87,
ShipName: "B' Beverages",
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10539,
CustomerID: 'BSBEV',
OrderDate: '1997-05-16T00:00:00.000Z',
ShippedDate: '1997-05-23T00:00:00.000Z',
Freight: 12.36,
ShipName: "B' Beverages",
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10540,
CustomerID: 'QUICK',
OrderDate: '1997-05-19T00:00:00.000Z',
ShippedDate: '1997-06-13T00:00:00.000Z',
Freight: 1007.64,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10541,
CustomerID: 'HANAR',
OrderDate: '1997-05-19T00:00:00.000Z',
ShippedDate: '1997-05-29T00:00:00.000Z',
Freight: 68.65,
ShipName: 'Hanari Carnes',
ShipAddress: 'Rua do Paço, 67',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10542,
CustomerID: 'KOENE',
OrderDate: '1997-05-20T00:00:00.000Z',
ShippedDate: '1997-05-26T00:00:00.000Z',
Freight: 10.95,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10543,
CustomerID: 'LILAS',
OrderDate: '1997-05-21T00:00:00.000Z',
ShippedDate: '1997-05-23T00:00:00.000Z',
Freight: 48.17,
ShipName: 'LILA-Supermercado',
ShipAddress: 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
ShipCity: 'Barquisimeto',
ShipRegion: 'Lara',
ShipCountry: 'Venezuela',
},
{
OrderID: 10544,
CustomerID: 'LONEP',
OrderDate: '1997-05-21T00:00:00.000Z',
ShippedDate: '1997-05-30T00:00:00.000Z',
Freight: 24.91,
ShipName: 'Lonesome Pine Restaurant',
ShipAddress: '89 Chiaroscuro Rd.',
ShipCity: 'Portland',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10545,
CustomerID: 'LAZYK',
OrderDate: '1997-05-22T00:00:00.000Z',
ShippedDate: '1997-06-26T00:00:00.000Z',
Freight: 11.92,
ShipName: 'Lazy K Kountry Store',
ShipAddress: '12 Orchestra Terrace',
ShipCity: 'Walla Walla',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10546,
CustomerID: 'VICTE',
OrderDate: '1997-05-23T00:00:00.000Z',
ShippedDate: '1997-05-27T00:00:00.000Z',
Freight: 194.72,
ShipName: 'Victuailles en stock',
ShipAddress: '2, rue du Commerce',
ShipCity: 'Lyon',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10547,
CustomerID: 'SEVES',
OrderDate: '1997-05-23T00:00:00.000Z',
ShippedDate: '1997-06-02T00:00:00.000Z',
Freight: 178.43,
ShipName: 'Seven Seas Imports',
ShipAddress: '90 Wadhurst Rd.',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10548,
CustomerID: 'TOMSP',
OrderDate: '1997-05-26T00:00:00.000Z',
ShippedDate: '1997-06-02T00:00:00.000Z',
Freight: 1.43,
ShipName: 'Toms Spezialitäten',
ShipAddress: 'Luisenstr. 48',
ShipCity: 'Münster',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10549,
CustomerID: 'QUICK',
OrderDate: '1997-05-27T00:00:00.000Z',
ShippedDate: '1997-05-30T00:00:00.000Z',
Freight: 171.24,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10550,
CustomerID: 'GODOS',
OrderDate: '1997-05-28T00:00:00.000Z',
ShippedDate: '1997-06-06T00:00:00.000Z',
Freight: 4.32,
ShipName: 'Godos Cocina Típica',
ShipAddress: 'C/ Romero, 33',
ShipCity: 'Sevilla',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10551,
CustomerID: 'FURIB',
OrderDate: '1997-05-28T00:00:00.000Z',
ShippedDate: '1997-06-06T00:00:00.000Z',
Freight: 72.95,
ShipName: 'Furia Bacalhau e Frutos do Mar',
ShipAddress: 'Jardim das rosas n. 32',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10552,
CustomerID: 'HILAA',
OrderDate: '1997-05-29T00:00:00.000Z',
ShippedDate: '1997-06-05T00:00:00.000Z',
Freight: 83.22,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10553,
CustomerID: 'WARTH',
OrderDate: '1997-05-30T00:00:00.000Z',
ShippedDate: '1997-06-03T00:00:00.000Z',
Freight: 149.49,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10554,
CustomerID: 'OTTIK',
OrderDate: '1997-05-30T00:00:00.000Z',
ShippedDate: '1997-06-05T00:00:00.000Z',
Freight: 120.97,
ShipName: 'Ottilies Käseladen',
ShipAddress: 'Mehrheimerstr. 369',
ShipCity: 'Köln',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10555,
CustomerID: 'SAVEA',
OrderDate: '1997-06-02T00:00:00.000Z',
ShippedDate: '1997-06-04T00:00:00.000Z',
Freight: 252.49,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10556,
CustomerID: 'SIMOB',
OrderDate: '1997-06-03T00:00:00.000Z',
ShippedDate: '1997-06-13T00:00:00.000Z',
Freight: 9.8,
ShipName: 'Simons bistro',
ShipAddress: 'Vinbæltet 34',
ShipCity: 'Kobenhavn',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10557,
CustomerID: 'LEHMS',
OrderDate: '1997-06-03T00:00:00.000Z',
ShippedDate: '1997-06-06T00:00:00.000Z',
Freight: 96.72,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10558,
CustomerID: 'AROUT',
OrderDate: '1997-06-04T00:00:00.000Z',
ShippedDate: '1997-06-10T00:00:00.000Z',
Freight: 72.97,
ShipName: 'Around the Horn',
ShipAddress: 'Brook Farm Stratford St. Mary',
ShipCity: 'Colchester',
ShipRegion: 'Essex',
ShipCountry: 'UK',
},
{
OrderID: 10559,
CustomerID: 'BLONP',
OrderDate: '1997-06-05T00:00:00.000Z',
ShippedDate: '1997-06-13T00:00:00.000Z',
Freight: 8.05,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10560,
CustomerID: 'FRANK',
OrderDate: '1997-06-06T00:00:00.000Z',
ShippedDate: '1997-06-09T00:00:00.000Z',
Freight: 36.65,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10561,
CustomerID: 'FOLKO',
OrderDate: '1997-06-06T00:00:00.000Z',
ShippedDate: '1997-06-09T00:00:00.000Z',
Freight: 242.21,
ShipName: 'Folk och fä HB',
ShipAddress: 'Åkergatan 24',
ShipCity: 'Bräcke',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10562,
CustomerID: 'REGGC',
OrderDate: '1997-06-09T00:00:00.000Z',
ShippedDate: '1997-06-12T00:00:00.000Z',
Freight: 22.95,
ShipName: 'Reggiani Caseifici',
ShipAddress: 'Strada Provinciale 124',
ShipCity: 'Reggio Emilia',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10563,
CustomerID: 'RICAR',
OrderDate: '1997-06-10T00:00:00.000Z',
ShippedDate: '1997-06-24T00:00:00.000Z',
Freight: 60.43,
ShipName: 'Ricardo Adocicados',
ShipAddress: 'Av. Copacabana, 267',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10564,
CustomerID: 'RATTC',
OrderDate: '1997-06-10T00:00:00.000Z',
ShippedDate: '1997-06-16T00:00:00.000Z',
Freight: 13.75,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10565,
CustomerID: 'MEREP',
OrderDate: '1997-06-11T00:00:00.000Z',
ShippedDate: '1997-06-18T00:00:00.000Z',
Freight: 7.15,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10566,
CustomerID: 'BLONP',
OrderDate: '1997-06-12T00:00:00.000Z',
ShippedDate: '1997-06-18T00:00:00.000Z',
Freight: 88.4,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10567,
CustomerID: 'HUNGO',
OrderDate: '1997-06-12T00:00:00.000Z',
ShippedDate: '1997-06-17T00:00:00.000Z',
Freight: 33.97,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10568,
CustomerID: 'GALED',
OrderDate: '1997-06-13T00:00:00.000Z',
ShippedDate: '1997-07-09T00:00:00.000Z',
Freight: 6.54,
ShipName: 'Galería del gastronómo',
ShipAddress: 'Rambla de Cataluña, 23',
ShipCity: 'Barcelona',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10569,
CustomerID: 'RATTC',
OrderDate: '1997-06-16T00:00:00.000Z',
ShippedDate: '1997-07-11T00:00:00.000Z',
Freight: 58.98,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10570,
CustomerID: 'MEREP',
OrderDate: '1997-06-17T00:00:00.000Z',
ShippedDate: '1997-06-19T00:00:00.000Z',
Freight: 188.99,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10571,
CustomerID: 'ERNSH',
OrderDate: '1997-06-17T00:00:00.000Z',
ShippedDate: '1997-07-04T00:00:00.000Z',
Freight: 26.06,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10572,
CustomerID: 'BERGS',
OrderDate: '1997-06-18T00:00:00.000Z',
ShippedDate: '1997-06-25T00:00:00.000Z',
Freight: 116.43,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10573,
CustomerID: 'ANTON',
OrderDate: '1997-06-19T00:00:00.000Z',
ShippedDate: '1997-06-20T00:00:00.000Z',
Freight: 84.84,
ShipName: 'Antonio Moreno Taquería',
ShipAddress: 'Mataderos 2312',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10574,
CustomerID: 'TRAIH',
OrderDate: '1997-06-19T00:00:00.000Z',
ShippedDate: '1997-06-30T00:00:00.000Z',
Freight: 37.6,
ShipName: "Trail' Head Gourmet Provisioners",
ShipAddress: '722 DaVinci Blvd.',
ShipCity: 'Kirkland',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10575,
CustomerID: 'MORGK',
OrderDate: '1997-06-20T00:00:00.000Z',
ShippedDate: '1997-06-30T00:00:00.000Z',
Freight: 127.34,
ShipName: 'Morgenstern Gesundkost',
ShipAddress: 'Heerstr. 22',
ShipCity: 'Leipzig',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10576,
CustomerID: 'TORTU',
OrderDate: '1997-06-23T00:00:00.000Z',
ShippedDate: '1997-06-30T00:00:00.000Z',
Freight: 18.56,
ShipName: 'Tortuga Restaurante',
ShipAddress: 'Avda. Azteca 123',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10577,
CustomerID: 'TRAIH',
OrderDate: '1997-06-23T00:00:00.000Z',
ShippedDate: '1997-06-30T00:00:00.000Z',
Freight: 25.41,
ShipName: "Trail' Head Gourmet Provisioners",
ShipAddress: '722 DaVinci Blvd.',
ShipCity: 'Kirkland',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10578,
CustomerID: 'BSBEV',
OrderDate: '1997-06-24T00:00:00.000Z',
ShippedDate: '1997-07-25T00:00:00.000Z',
Freight: 29.6,
ShipName: "B' Beverages",
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10579,
CustomerID: 'LETSS',
OrderDate: '1997-06-25T00:00:00.000Z',
ShippedDate: '1997-07-04T00:00:00.000Z',
Freight: 13.73,
ShipName: "Let' Stop N Shop",
ShipAddress: '87 Polk St. Suite 5',
ShipCity: 'San Francisco',
ShipRegion: 'CA',
ShipCountry: 'USA',
},
{
OrderID: 10580,
CustomerID: 'OTTIK',
OrderDate: '1997-06-26T00:00:00.000Z',
ShippedDate: '1997-07-01T00:00:00.000Z',
Freight: 75.89,
ShipName: 'Ottilies Käseladen',
ShipAddress: 'Mehrheimerstr. 369',
ShipCity: 'Köln',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10581,
CustomerID: 'FAMIA',
OrderDate: '1997-06-26T00:00:00.000Z',
ShippedDate: '1997-07-02T00:00:00.000Z',
Freight: 3.01,
ShipName: 'Familia Arquibaldo',
ShipAddress: 'Rua Orós, 92',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10582,
CustomerID: 'BLAUS',
OrderDate: '1997-06-27T00:00:00.000Z',
ShippedDate: '1997-07-14T00:00:00.000Z',
Freight: 27.71,
ShipName: 'Blauer See Delikatessen',
ShipAddress: 'Forsterstr. 57',
ShipCity: 'Mannheim',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10583,
CustomerID: 'WARTH',
OrderDate: '1997-06-30T00:00:00.000Z',
ShippedDate: '1997-07-04T00:00:00.000Z',
Freight: 7.28,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10584,
CustomerID: 'BLONP',
OrderDate: '1997-06-30T00:00:00.000Z',
ShippedDate: '1997-07-04T00:00:00.000Z',
Freight: 59.14,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10585,
CustomerID: 'WELLI',
OrderDate: '1997-07-01T00:00:00.000Z',
ShippedDate: '1997-07-10T00:00:00.000Z',
Freight: 13.41,
ShipName: 'Wellington Importadora',
ShipAddress: 'Rua do Mercado, 12',
ShipCity: 'Resende',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10586,
CustomerID: 'REGGC',
OrderDate: '1997-07-02T00:00:00.000Z',
ShippedDate: '1997-07-09T00:00:00.000Z',
Freight: 0.48,
ShipName: 'Reggiani Caseifici',
ShipAddress: 'Strada Provinciale 124',
ShipCity: 'Reggio Emilia',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10587,
CustomerID: 'QUEDE',
OrderDate: '1997-07-02T00:00:00.000Z',
ShippedDate: '1997-07-09T00:00:00.000Z',
Freight: 62.52,
ShipName: 'Que Delícia',
ShipAddress: 'Rua da Panificadora, 12',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10588,
CustomerID: 'QUICK',
OrderDate: '1997-07-03T00:00:00.000Z',
ShippedDate: '1997-07-10T00:00:00.000Z',
Freight: 194.67,
ShipName: 'QUICK-Stop',
ShipAddress: 'Taucherstraße 10',
ShipCity: 'Cunewalde',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10589,
CustomerID: 'GREAL',
OrderDate: '1997-07-04T00:00:00.000Z',
ShippedDate: '1997-07-14T00:00:00.000Z',
Freight: 4.42,
ShipName: 'Great Lakes Food Market',
ShipAddress: '2732 Baker Blvd.',
ShipCity: 'Eugene',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10590,
CustomerID: 'MEREP',
OrderDate: '1997-07-07T00:00:00.000Z',
ShippedDate: '1997-07-14T00:00:00.000Z',
Freight: 44.77,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10591,
CustomerID: 'VAFFE',
OrderDate: '1997-07-07T00:00:00.000Z',
ShippedDate: '1997-07-16T00:00:00.000Z',
Freight: 55.92,
ShipName: 'Vaffeljernet',
ShipAddress: 'Smagsloget 45',
ShipCity: 'Århus',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10592,
CustomerID: 'LEHMS',
OrderDate: '1997-07-08T00:00:00.000Z',
ShippedDate: '1997-07-16T00:00:00.000Z',
Freight: 32.1,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10593,
CustomerID: 'LEHMS',
OrderDate: '1997-07-09T00:00:00.000Z',
ShippedDate: '1997-08-13T00:00:00.000Z',
Freight: 174.2,
ShipName: 'Lehmanns Marktstand',
ShipAddress: 'Magazinweg 7',
ShipCity: 'Frankfurt a.M.',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10594,
CustomerID: 'OLDWO',
OrderDate: '1997-07-09T00:00:00.000Z',
ShippedDate: '1997-07-16T00:00:00.000Z',
Freight: 5.24,
ShipName: 'Old World Delicatessen',
ShipAddress: '2743 Bering St.',
ShipCity: 'Anchorage',
ShipRegion: 'AK',
ShipCountry: 'USA',
},
{
OrderID: 10595,
CustomerID: 'ERNSH',
OrderDate: '1997-07-10T00:00:00.000Z',
ShippedDate: '1997-07-14T00:00:00.000Z',
Freight: 96.78,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10596,
CustomerID: 'WHITC',
OrderDate: '1997-07-11T00:00:00.000Z',
ShippedDate: '1997-08-12T00:00:00.000Z',
Freight: 16.34,
ShipName: 'White Clover Markets',
ShipAddress: '1029 - 12th Ave. S.',
ShipCity: 'Seattle',
ShipRegion: 'WA',
ShipCountry: 'USA',
},
{
OrderID: 10597,
CustomerID: 'PICCO',
OrderDate: '1997-07-11T00:00:00.000Z',
ShippedDate: '1997-07-18T00:00:00.000Z',
Freight: 35.12,
ShipName: 'Piccolo und mehr',
ShipAddress: 'Geislweg 14',
ShipCity: 'Salzburg',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10598,
CustomerID: 'RATTC',
OrderDate: '1997-07-14T00:00:00.000Z',
ShippedDate: '1997-07-18T00:00:00.000Z',
Freight: 44.42,
ShipName: 'Rattlesnake Canyon Grocery',
ShipAddress: '2817 Milton Dr.',
ShipCity: 'Albuquerque',
ShipRegion: 'NM',
ShipCountry: 'USA',
},
{
OrderID: 10599,
CustomerID: 'BSBEV',
OrderDate: '1997-07-15T00:00:00.000Z',
ShippedDate: '1997-07-21T00:00:00.000Z',
Freight: 29.98,
ShipName: 'B Beverages',
ShipAddress: 'Fauntleroy Circus',
ShipCity: 'London',
ShipRegion: null,
ShipCountry: 'UK',
},
{
OrderID: 10600,
CustomerID: 'HUNGC',
OrderDate: '1997-07-16T00:00:00.000Z',
ShippedDate: '1997-07-21T00:00:00.000Z',
Freight: 45.13,
ShipName: 'Hungry Coyote Import Store',
ShipAddress: 'City Center Plaza 516 Main St.',
ShipCity: 'Elgin',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10601,
CustomerID: 'HILAA',
OrderDate: '1997-07-16T00:00:00.000Z',
ShippedDate: '1997-07-22T00:00:00.000Z',
Freight: 58.3,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10602,
CustomerID: 'VAFFE',
OrderDate: '1997-07-17T00:00:00.000Z',
ShippedDate: '1997-07-22T00:00:00.000Z',
Freight: 2.92,
ShipName: 'Vaffeljernet',
ShipAddress: 'Smagsloget 45',
ShipCity: 'Århus',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10603,
CustomerID: 'SAVEA',
OrderDate: '1997-07-18T00:00:00.000Z',
ShippedDate: '1997-08-08T00:00:00.000Z',
Freight: 48.77,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10604,
CustomerID: 'FURIB',
OrderDate: '1997-07-18T00:00:00.000Z',
ShippedDate: '1997-07-29T00:00:00.000Z',
Freight: 7.46,
ShipName: 'Furia Bacalhau e Frutos do Mar',
ShipAddress: 'Jardim das rosas n. 32',
ShipCity: 'Lisboa',
ShipRegion: null,
ShipCountry: 'Portugal',
},
{
OrderID: 10605,
CustomerID: 'MEREP',
OrderDate: '1997-07-21T00:00:00.000Z',
ShippedDate: '1997-07-29T00:00:00.000Z',
Freight: 379.13,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10606,
CustomerID: 'TRADH',
OrderDate: '1997-07-22T00:00:00.000Z',
ShippedDate: '1997-07-31T00:00:00.000Z',
Freight: 79.4,
ShipName: 'Tradiçao Hipermercados',
ShipAddress: 'Av. Inês de Castro, 414',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10607,
CustomerID: 'SAVEA',
OrderDate: '1997-07-22T00:00:00.000Z',
ShippedDate: '1997-07-25T00:00:00.000Z',
Freight: 200.24,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10608,
CustomerID: 'TOMSP',
OrderDate: '1997-07-23T00:00:00.000Z',
ShippedDate: '1997-08-01T00:00:00.000Z',
Freight: 27.79,
ShipName: 'Toms Spezialitäten',
ShipAddress: 'Luisenstr. 48',
ShipCity: 'Münster',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10609,
CustomerID: 'DUMON',
OrderDate: '1997-07-24T00:00:00.000Z',
ShippedDate: '1997-07-30T00:00:00.000Z',
Freight: 1.85,
ShipName: 'Du monde entier',
ShipAddress: '67, rue des Cinquante Otages',
ShipCity: 'Nantes',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10610,
CustomerID: 'LAMAI',
OrderDate: '1997-07-25T00:00:00.000Z',
ShippedDate: '1997-08-06T00:00:00.000Z',
Freight: 26.78,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10611,
CustomerID: 'WOLZA',
OrderDate: '1997-07-25T00:00:00.000Z',
ShippedDate: '1997-08-01T00:00:00.000Z',
Freight: 80.65,
ShipName: 'Wolski Zajazd',
ShipAddress: 'ul. Filtrowa 68',
ShipCity: 'Warszawa',
ShipRegion: null,
ShipCountry: 'Poland',
},
{
OrderID: 10612,
CustomerID: 'SAVEA',
OrderDate: '1997-07-28T00:00:00.000Z',
ShippedDate: '1997-08-01T00:00:00.000Z',
Freight: 544.08,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10613,
CustomerID: 'HILAA',
OrderDate: '1997-07-29T00:00:00.000Z',
ShippedDate: '1997-08-01T00:00:00.000Z',
Freight: 8.11,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10614,
CustomerID: 'BLAUS',
OrderDate: '1997-07-29T00:00:00.000Z',
ShippedDate: '1997-08-01T00:00:00.000Z',
Freight: 1.93,
ShipName: 'Blauer See Delikatessen',
ShipAddress: 'Forsterstr. 57',
ShipCity: 'Mannheim',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10615,
CustomerID: 'WILMK',
OrderDate: '1997-07-30T00:00:00.000Z',
ShippedDate: '1997-08-06T00:00:00.000Z',
Freight: 0.75,
ShipName: 'Wilman Kala',
ShipAddress: 'Keskuskatu 45',
ShipCity: 'Helsinki',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10616,
CustomerID: 'GREAL',
OrderDate: '1997-07-31T00:00:00.000Z',
ShippedDate: '1997-08-05T00:00:00.000Z',
Freight: 116.53,
ShipName: 'Great Lakes Food Market',
ShipAddress: '2732 Baker Blvd.',
ShipCity: 'Eugene',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10617,
CustomerID: 'GREAL',
OrderDate: '1997-07-31T00:00:00.000Z',
ShippedDate: '1997-08-04T00:00:00.000Z',
Freight: 18.53,
ShipName: 'Great Lakes Food Market',
ShipAddress: '2732 Baker Blvd.',
ShipCity: 'Eugene',
ShipRegion: 'OR',
ShipCountry: 'USA',
},
{
OrderID: 10618,
CustomerID: 'MEREP',
OrderDate: '1997-08-01T00:00:00.000Z',
ShippedDate: '1997-08-08T00:00:00.000Z',
Freight: 154.68,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10619,
CustomerID: 'MEREP',
OrderDate: '1997-08-04T00:00:00.000Z',
ShippedDate: '1997-08-07T00:00:00.000Z',
Freight: 91.05,
ShipName: 'Mère Paillarde',
ShipAddress: '43 rue St. Laurent',
ShipCity: 'Montréal',
ShipRegion: 'Québec',
ShipCountry: 'Canada',
},
{
OrderID: 10620,
CustomerID: 'LAUGB',
OrderDate: '1997-08-05T00:00:00.000Z',
ShippedDate: '1997-08-14T00:00:00.000Z',
Freight: 0.94,
ShipName: 'Laughing Bacchus Wine Cellars',
ShipAddress: '2319 Elm St.',
ShipCity: 'Vancouver',
ShipRegion: 'BC',
ShipCountry: 'Canada',
},
{
OrderID: 10621,
CustomerID: 'ISLAT',
OrderDate: '1997-08-05T00:00:00.000Z',
ShippedDate: '1997-08-11T00:00:00.000Z',
Freight: 23.73,
ShipName: 'Island Trading',
ShipAddress: 'Garden House Crowther Way',
ShipCity: 'Cowes',
ShipRegion: 'Isle of Wight',
ShipCountry: 'UK',
},
{
OrderID: 10622,
CustomerID: 'RICAR',
OrderDate: '1997-08-06T00:00:00.000Z',
ShippedDate: '1997-08-11T00:00:00.000Z',
Freight: 50.97,
ShipName: 'Ricardo Adocicados',
ShipAddress: 'Av. Copacabana, 267',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10623,
CustomerID: 'FRANK',
OrderDate: '1997-08-07T00:00:00.000Z',
ShippedDate: '1997-08-12T00:00:00.000Z',
Freight: 97.18,
ShipName: 'Frankenversand',
ShipAddress: 'Berliner Platz 43',
ShipCity: 'München',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10624,
CustomerID: 'THECR',
OrderDate: '1997-08-07T00:00:00.000Z',
ShippedDate: '1997-08-19T00:00:00.000Z',
Freight: 94.8,
ShipName: 'The Cracker Box',
ShipAddress: '55 Grizzly Peak Rd.',
ShipCity: 'Butte',
ShipRegion: 'MT',
ShipCountry: 'USA',
},
{
OrderID: 10625,
CustomerID: 'ANATR',
OrderDate: '1997-08-08T00:00:00.000Z',
ShippedDate: '1997-08-14T00:00:00.000Z',
Freight: 43.9,
ShipName: 'Ana Trujillo Emparedados y helados',
ShipAddress: 'Avda. de la Constitución 2222',
ShipCity: 'México D.F.',
ShipRegion: null,
ShipCountry: 'Mexico',
},
{
OrderID: 10626,
CustomerID: 'BERGS',
OrderDate: '1997-08-11T00:00:00.000Z',
ShippedDate: '1997-08-20T00:00:00.000Z',
Freight: 138.69,
ShipName: 'Berglunds snabbköp',
ShipAddress: 'Berguvsvägen 8',
ShipCity: 'Luleå',
ShipRegion: null,
ShipCountry: 'Sweden',
},
{
OrderID: 10627,
CustomerID: 'SAVEA',
OrderDate: '1997-08-11T00:00:00.000Z',
ShippedDate: '1997-08-21T00:00:00.000Z',
Freight: 107.46,
ShipName: 'Save-a-lot Markets',
ShipAddress: '187 Suffolk Ln.',
ShipCity: 'Boise',
ShipRegion: 'ID',
ShipCountry: 'USA',
},
{
OrderID: 10628,
CustomerID: 'BLONP',
OrderDate: '1997-08-12T00:00:00.000Z',
ShippedDate: '1997-08-20T00:00:00.000Z',
Freight: 30.36,
ShipName: 'Blondel père et fils',
ShipAddress: '24, place Kléber',
ShipCity: 'Strasbourg',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10629,
CustomerID: 'GODOS',
OrderDate: '1997-08-12T00:00:00.000Z',
ShippedDate: '1997-08-20T00:00:00.000Z',
Freight: 85.46,
ShipName: 'Godos Cocina Típica',
ShipAddress: 'C/ Romero, 33',
ShipCity: 'Sevilla',
ShipRegion: null,
ShipCountry: 'Spain',
},
{
OrderID: 10630,
CustomerID: 'KOENE',
OrderDate: '1997-08-13T00:00:00.000Z',
ShippedDate: '1997-08-19T00:00:00.000Z',
Freight: 32.35,
ShipName: 'Königlich Essen',
ShipAddress: 'Maubelstr. 90',
ShipCity: 'Brandenburg',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10631,
CustomerID: 'LAMAI',
OrderDate: '1997-08-14T00:00:00.000Z',
ShippedDate: '1997-08-15T00:00:00.000Z',
Freight: 0.87,
ShipName: "La maison d'Asie",
ShipAddress: '1 rue Alsace-Lorraine',
ShipCity: 'Toulouse',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10632,
CustomerID: 'WANDK',
OrderDate: '1997-08-14T00:00:00.000Z',
ShippedDate: '1997-08-19T00:00:00.000Z',
Freight: 41.38,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10633,
CustomerID: 'ERNSH',
OrderDate: '1997-08-15T00:00:00.000Z',
ShippedDate: '1997-08-18T00:00:00.000Z',
Freight: 477.9,
ShipName: 'Ernst Handel',
ShipAddress: 'Kirchgasse 6',
ShipCity: 'Graz',
ShipRegion: null,
ShipCountry: 'Austria',
},
{
OrderID: 10634,
CustomerID: 'FOLIG',
OrderDate: '1997-08-15T00:00:00.000Z',
ShippedDate: '1997-08-21T00:00:00.000Z',
Freight: 487.38,
ShipName: 'Folies gourmandes',
ShipAddress: '184, chaussée de Tournai',
ShipCity: 'Lille',
ShipRegion: null,
ShipCountry: 'France',
},
{
OrderID: 10635,
CustomerID: 'MAGAA',
OrderDate: '1997-08-18T00:00:00.000Z',
ShippedDate: '1997-08-21T00:00:00.000Z',
Freight: 47.46,
ShipName: 'Magazzini Alimentari Riuniti',
ShipAddress: 'Via Ludovico il Moro 22',
ShipCity: 'Bergamo',
ShipRegion: null,
ShipCountry: 'Italy',
},
{
OrderID: 10636,
CustomerID: 'WARTH',
OrderDate: '1997-08-19T00:00:00.000Z',
ShippedDate: '1997-08-26T00:00:00.000Z',
Freight: 1.15,
ShipName: 'Wartian Herkku',
ShipAddress: 'Torikatu 38',
ShipCity: 'Oulu',
ShipRegion: null,
ShipCountry: 'Finland',
},
{
OrderID: 10637,
CustomerID: 'QUEEN',
OrderDate: '1997-08-19T00:00:00.000Z',
ShippedDate: '1997-08-26T00:00:00.000Z',
Freight: 201.29,
ShipName: 'Queen Cozinha',
ShipAddress: 'Alameda dos Canàrios, 891',
ShipCity: 'Sao Paulo',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10638,
CustomerID: 'LINOD',
OrderDate: '1997-08-20T00:00:00.000Z',
ShippedDate: '1997-09-01T00:00:00.000Z',
Freight: 158.44,
ShipName: 'LINO-Delicateses',
ShipAddress: 'Ave. 5 de Mayo Porlamar',
ShipCity: 'I. de Margarita',
ShipRegion: 'Nueva Esparta',
ShipCountry: 'Venezuela',
},
{
OrderID: 10639,
CustomerID: 'SANTG',
OrderDate: '1997-08-20T00:00:00.000Z',
ShippedDate: '1997-08-27T00:00:00.000Z',
Freight: 38.64,
ShipName: 'Santé Gourmet',
ShipAddress: 'Erling Skakkes gate 78',
ShipCity: 'Stavern',
ShipRegion: null,
ShipCountry: 'Norway',
},
{
OrderID: 10640,
CustomerID: 'WANDK',
OrderDate: '1997-08-21T00:00:00.000Z',
ShippedDate: '1997-08-28T00:00:00.000Z',
Freight: 23.55,
ShipName: 'Die Wandernde Kuh',
ShipAddress: 'Adenauerallee 900',
ShipCity: 'Stuttgart',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10641,
CustomerID: 'HILAA',
OrderDate: '1997-08-22T00:00:00.000Z',
ShippedDate: '1997-08-26T00:00:00.000Z',
Freight: 179.61,
ShipName: 'HILARION-Abastos',
ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipCity: 'San Cristóbal',
ShipRegion: 'Táchira',
ShipCountry: 'Venezuela',
},
{
OrderID: 10642,
CustomerID: 'SIMOB',
OrderDate: '1997-08-22T00:00:00.000Z',
ShippedDate: '1997-09-05T00:00:00.000Z',
Freight: 41.89,
ShipName: 'Simons bistro',
ShipAddress: 'Vinbæltet 34',
ShipCity: 'Kobenhavn',
ShipRegion: null,
ShipCountry: 'Denmark',
},
{
OrderID: 10643,
CustomerID: 'ALFKI',
OrderDate: '1997-08-25T00:00:00.000Z',
ShippedDate: '1997-09-02T00:00:00.000Z',
Freight: 29.46,
ShipName: 'Alfreds Futterkiste',
ShipAddress: 'Obere Str. 57',
ShipCity: 'Berlin',
ShipRegion: null,
ShipCountry: 'Germany',
},
{
OrderID: 10644,
CustomerID: 'WELLI',
OrderDate: '1997-08-25T00:00:00.000Z',
ShippedDate: '1997-09-01T00:00:00.000Z',
Freight: 0.14,
ShipName: 'Wellington Importadora',
ShipAddress: 'Rua do Mercado, 12',
ShipCity: 'Resende',
ShipRegion: 'SP',
ShipCountry: 'Brazil',
},
{
OrderID: 10645,
CustomerID: 'HANAR',
OrderDate: '1997-08-26T00:00:00.000Z',
ShippedDate: '1997-09-02T00:00:00.000Z',
Freight: 12.41,
ShipName: 'Hanari Carnes',
ShipAddress: 'Rua do Paço, 67',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10646,
CustomerID: 'HUNGO',
OrderDate: '1997-08-27T00:00:00.000Z',
ShippedDate: '1997-09-03T00:00:00.000Z',
Freight: 142.33,
ShipName: 'Hungry Owl All-Night Grocers',
ShipAddress: '8 Johnstown Road',
ShipCity: 'Cork',
ShipRegion: 'Co. Cork',
ShipCountry: 'Ireland',
},
{
OrderID: 10647,
CustomerID: 'QUEDE',
OrderDate: '1997-08-27T00:00:00.000Z',
ShippedDate: '1997-09-03T00:00:00.000Z',
Freight: 45.54,
ShipName: 'Que Delícia',
ShipAddress: 'Rua da Panificadora, 12',
ShipCity: 'Rio de Janeiro',
ShipRegion: 'RJ',
ShipCountry: 'Brazil',
},
{
OrderID: 10648,
CustomerID: 'RICAR'