Here's my issue,
I create an instance of Excel and write an entry to the default worksheet.
I place a title in the first entry.
If I get a count to write the next entry under the first Rows.Count returns 0.
If I save the workbook the Rows.Count property returns 1.
I'd prefer to finish write everything out Row by Row and Column by Column before having to call save. I don't want to call save after every entry I make.
I'm most likely doing something wrong...
Here's my sample code.
Excel workbook = new Excel();
workbook.Worksheets.Name = "Report";
workbook.Worksheets["Report"].Cells[0, 0].PutValue("Some value goes here...");
Thanks in advance.
(FYI, we're also evaluating Aspose.Cells for another project involving importing and exporting DataTables, but I decided to kill 2 birds with one stone and see if I can use Aspose.Cells to replace an in house reporting tool as well. )