static void Main(string[] args)
{
using (var spreadsheet1 = new Spreadsheet())
{
// ------------ PREPARE DATA ------------
IEnumerable <Person> people = GetTestCollection();
DataTable cars = GetTestDataTable();
// ------------ INSERT ROW(S) / TABLE ------------
// Insert all people
var sheet1 = spreadsheet1.GetSheetByNameWithHeader("Everyone", new string[] { "Name", "Age", "IsMale", "Date of birth" });
spreadsheet1.InsertRows(sheet1, people.Select(x => x.ConvertToRow()), autofit: false);
// Insert one single row
spreadsheet1.InsertRowAtEnd(sheet1, new Person {
Name = "Dog", Age = 3, DateOfBirth = new DateTime(2018, 4, 21), IsMale = true
}.ConvertToRow());
spreadsheet1.Autofit(sheet1);
// Insert adults only (new Adults sheet will be inserted), no header and will leave one blank column and one blank row
spreadsheet1.InsertRows(sheetName: "Adults", people.Where(x => x.Age >= 18).Select(x => x.ConvertToRow()), rowIndex: 2, columnIndex: 2, autofit: true);
// Insert cars, first using default row generator then using custom row generator
spreadsheet1.InsertTable(cars, includeHeader: true);
var sheet3 = spreadsheet1.GetSheetByName(cars.TableName);
spreadsheet1.InsertTable(cars, sheetName: "custom built cars", includeHeader: true, rowConverter: (x) => Car.ConvertToRow(x), autofit: true, rowIndex: 10);
spreadsheet1.InsertImage("custom built cars", "tux.png", imageHeightPixel: 75, imageWidthPixel: 125);
// ------------ SAVE AS EXCEL / CSV / SERIALIZE DATA ------------
// Excel with 4 sheets
spreadsheet1.SaveExcelAs("test");
spreadsheet1.SaveExcelAs("test2", password: "******");
// 4 Csv files, will create a new folder and place the files inside, one per sheet
spreadsheet1.SaveCsvAs(basePath: "temp");
// 1 Csv file, for sheet1
spreadsheet1.SaveCsvAs(sheet1, "test");
// Serialize "would be" content of Excel in byte[] form
var bytes1 = spreadsheet1.SerializeExcel();
// Serialize "would be" content of csv sheet3 in byte[] form
var bytes2 = spreadsheet1.SerializeCsv(sheet3);
// String content of csv sheet3
List <string> csvSheet3 = spreadsheet1.GetSheetAsCsv(sheet3);
string allInOne = spreadsheet1.GetSheetAsCsvString(sheet3);
}
}
