Maximize productivity with
30% off* for a limited time
using BOOSTDEV30.
Includes 3- and 5-packs.
*Some exclusions may apply.New Product LaunchBoldDesk: Help desk ticketing software starts at $10 for 3 agents.
Try it for free.ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Create(1);
IWorksheet worksheet = workbook.Worksheets[0];
worksheet[1,
1].Text = "";
worksheet[1,
2].Text = "";
using (FileStream fileStream = new FileStream(filePath,
FileMode.CreateNew))
{
worksheet.SaveAs(fileStream, ";", Encoding.Default);
}
workbook.Close();
excelEngine.Dispose();
Output expected: ;;
How can I fix?
sheet["A1:C1"].Text = "blank cells";
sheet["A1:C1"].Text = ""; |