static void Main(string[] args) { string title = "Excel Labs NuGet"; string sheetName = "Simple and Fast"; // TODO: create a folder named Files to run this demo // TODO: or, you may change the path // TODO: full path: C:\Users\...\ExcelLabs\Excel.Labs.NET5Demo\bin\Debug\net6.0\Files string path = AppDomain.CurrentDomain.BaseDirectory + @"Files\"; // 1. create a cell list List <Cellx> cells = new(); // 2. values as an array List <string> languages = new() { "Java", // A "C#", // B "Javascript", // C "Swift", // D "Php", // E "Python", // F "Go", // G "Swift", // H "", // I "", // J "", // K "Objective-C", // L "C++", // M "F#" // N }; foreach (string lang in languages) { // no column name for ordered columns cells.Add(new Cellx(1, lang)); } // 3. single value with column name cells.Add(new Cellx(2, "Fortran", "A")); cells.Add(new Cellx(2, "Cobol", "D")); cells.Add(new Cellx(2, "Pascal", "I")); // 4. single value without column name cells.Add(new Cellx(3, "Visual Studio")); cells.Add(new Cellx(3, "Webstorm")); cells.Add(new Cellx(3, "XCode")); cells.Add(new Cellx(3, "Notepad")); // call save function ExcelLabs.SaveFile(title, path, sheetName, cells); Console.WriteLine("Done. Check the path now to see the Excel file."); Console.ReadLine(); } }
static void Main(string[] args) { string title = "Excel Labs NuGet"; string sheetName = "Simple and Fast"; string path = AppDomain.CurrentDomain.BaseDirectory + @"Files\"; // 1. create a cell list List <Cellx> cells = new List <Cellx>(); // 2. values as an array List <string> languages = new List <string>() { "Java", // A "C#", // B "Javascript", // C "Swift", // D "Php", // E "Python", // F "Go", // G "Swift", // H "", // I "", // J "", // K "Objective-C", // L "C++", // M "F#" }; // N foreach (string lang in languages) { // no column name for ordered columns cells.Add(new Cellx(1, lang)); } // 3. single value with column name cells.Add(new Cellx(2, "Fortran", "A")); cells.Add(new Cellx(2, "Cobol", "D")); cells.Add(new Cellx(2, "Pascal", "I")); // 4. single value without column name cells.Add(new Cellx(3, "Visual Studio")); cells.Add(new Cellx(3, "Webstorm")); cells.Add(new Cellx(3, "XCode")); cells.Add(new Cellx(3, "Notepad")); // call save function ExcelLabs.SaveFile(title, path, sheetName, cells); Console.WriteLine("done."); Console.ReadLine(); }