Are Cells limiited to 256

[andrew1]

Using the following code, the sheet size stops at column “IV” (256 wide). How do I get a wider sheet?

//Instantiate a new workbook

Workbook workbook = new Workbook();

//Get the first worksheet in the workbook

Worksheet worksheet = workbook.Worksheets[0];

//Get the cells collection in the sheet

Cells cells = worksheet.Cells;

[shakeel.faiz]

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

You should use XLSX format because it is a new format. XLS is an older format and supports less columns.

By default, workbook object is created in XLS format.

Please try creating workbook object like this and see if it resolves your problem.

C#

Workbook workbook = new Workbook(FileFormatType.Xlsx);