public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { object[,] data = new object[, ] { { "Name", "City", "Birthday", "Sex", "Weight", "Height" }, { "Bob", "NewYork", new DateTime(1968, 6, 8), "male", 80, 180 }, { "Betty", "NewYork", new DateTime(1972, 7, 3), "female", 72, 168 }, { "Gary", "NewYork", new DateTime(1964, 3, 2), "male", 71, 179 }, { "Hunk", "Washington", new DateTime(1972, 8, 8), "male", 80, 171 }, { "Cherry", "Washington", new DateTime(1986, 2, 2), "female", 58, 161 }, { "Eva", "Washington", new DateTime(1993, 2, 5), "female", 71, 180 } }; //Set data. IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1:F7"].Value = data; sheet.Tables.Add(sheet.Range["A1:F7"], true); //Save csv options CsvSaveOptions options = new CsvSaveOptions(); options.SeparatorString = "-"; //Change the path to real export path when save. workbook.Save(this.CurrentDirectory + "dest.csv", options); }
public static void SaveCvs([NotNull] ExcelFile ef, [NotNull] string file) { var options = new CsvSaveOptions(CsvType.SemicolonDelimited); ef.Save(file, options); ConvertToLatin1(file); }
static void Example3() { var workbook = new ExcelFile(); var worksheet = workbook.Worksheets.Add("Sheet1"); // Tabular sample data for exporting into a CSV file. var skyscrapers = new object[, ] { { "Rank", "Building", "City", "Country", "Height (m)", "Height (ft)", "Floors", "Built" }, { 1, "Burj Khalifa", "Dubai", "United Arab Emirates", 829.8, 2722, 163, 2010 }, { 2, "Shanghai Tower", "Shanghai", "China", 632, 2073, 128, 2015 }, { 3, "Abraj Al-Bait Towers", "Mecca", "Saudi Arabia", 601, 1971, 120, 2012 }, { 4, "Ping An Finance Center", "Shenzhen", "China", 599, 1965, 115, 2016 }, { 5, "Lotte World Tower", "Seoul", "South Korea", 555.7, 1823, 123, 2016 }, { 6, "One World Trade Center", "New York City", "United States", 546.2, 1792, 104, 2014 }, { 7, "Guangzhou CTF Finance Centre", "Guangzhou", "China", 530, 1739, 111, 2016 }, { 7, "Tianjin CTF Finance Centre", "Tianjin", "China", 530, 1739, 98, 2018 }, { 9, "China Zun", "Beijing", "China", 528, 1732, 108, 2018 }, { 10, "Willis Tower", "Chicago", "United States", 527, 1729, 108, 1974 }, { 11, "Taipei 101", "Taipei", "Taiwan", 508, 1667, 101, 2004 }, { 12, "Shanghai World Financial Center", "Shanghai", "China", 494.3, 1622, 101, 2008 }, { 13, "International Commerce Centre", "Hong Kong", "China", 484, 1588, 118, 2010 }, { 15, "Central Park Tower", "New York City", "United States", 472.4, 1550, 103, 2020 }, { 16, "Landmark 81", "Ho Chi Minh City", "Vietnam", 469.5, 1540, 81, 2018 }, { 17, "Lakhta Center", "St. Petersburg", "Russia", 462, 1516, 86, 2018 }, { 18, "John Hancock Center", "Chicago", "United States", 456.9, 1499, 100, 1969 }, { 19, "Changsha IFS Tower T1", "Changsha", "China", 452, 1483, 94, 2017 }, { 20, "Petronas Tower 1", "Kuala Lumpur", "Malaysia", 451.9, 1483, 88, 1998 }, { 20, "Petronas Tower 2", "Kuala Lumpur", "Malaysia", 451.9, 1483, 88, 1998 }, { 22, "Zifeng Tower", "Nanjing", "China", 450, 1476, 89, 2009 }, { 22, "Suzhou IFS", "Suzhou", "China", 450, 1476, 98, 2017 }, { 24, "The Exchange 106", "Kuala Lumpur", "Malaysia", 445.1, 1460, 95, 2018 }, { 25, "Empire State Building", "New York City", "United States", 443.2, 1454, 102, 1931 }, { 26, "Kingkey 100", "Shenzhen", "China", 442, 1449, 100, 2011 }, { 27, "Guangzhou International Finance Center", "Guangzhou", "China", 438.6, 1445, 103, 2009 }, { 28, "Wuhan Center", "Wuhan", "China", 438, 1437, 88, 2017 }, { 29, "111 West 57th Street", "New York City", "United States", 435.3, 1428, 82, 2019 }, { 30, "Dongguan International Trade Center 1", "Dongguan", "China", 426.9, 1401, 88, 2019 }, { 31, "One Vanderbilt", "New York City", "United States", 427, 1401, 58, 2019 }, { 32, "432 Park Avenue", "New York City", "United States", 425.5, 1396, 85, 2015 }, { 33, "Marina 101", "Dubai", "United Arab Emirates", 425, 1394, 101, 2017 }, { 34, "Trump International Hotel and Tower", "Chicago", "United States", 423.2, 1388, 96, 2009 }, { 35, "Jin Mao Tower", "Shanghai", "China", 421, 1381, 88, 1998 }, { 36, "Princess Tower", "Dubai", "United Arab Emirates", 414, 1358, 101, 2012 }, { 37, "Al Hamra Tower", "Kuwait City", "Kuwait", 412.6, 1354, 80, 2010 }, { 38, "Two International Finance Centre", "Hong Kong", "China", 412, 1352, 88, 2003 }, { 39, "Haeundae LCT The Sharp Landmark Tower", "Busan", "South Korea", 411.6, 1350, 101, 2019 }, { 40, "Guangxi China Resources Tower", "Nanning", "China", 402.7, 1321, 85, 2018 }, { 41, "Guiyang Financial Center Tower 1", "Guiyang", "China", 401, 1316, 79, 2020 } }; // Write data into Excel cells. int rowCount = skyscrapers.GetLength(0); int columnCount = skyscrapers.GetLength(1); for (int row = 0; row < rowCount; row++) { for (int column = 0; column < columnCount; column++) { worksheet.Cells[row, column].Value = skyscrapers[row, column]; } } // Format Excel columns. worksheet.Columns["E"].Style.NumberFormat = @"0.0 \m"; worksheet.Columns["F"].Style.NumberFormat = @"0,000 \f\t"; var csvOptions = new CsvSaveOptions(CsvType.CommaDelimited) { UseFormattedValues = true }; // Write CSV file using specified CsvSaveOptions. workbook.Save("Skyscrapers.csv", csvOptions); }