"Column out of Range" Error when populating an Excel Sheet

Question

I just started implementing this to populate an Excel sheet with some data:

using OfficeOpenXml; //.. ExcelWorksheet VerificationSheet_Sheet4 = package.Workbook.Worksheets.Add("SheetTitleHere"); int row = 0, col = 0; VerificationSheet_Sheet4.Cells[row + 1, col].Value = "AnyStringHere"; // error here

However it pops an error saying column is out of range. Why and how can I fix that?

Steve · Accepted Answer · 2016-06-20 15:33:35Z

25

Excel worksheets use 1 based indexing rather than zero based. Thus columns and rows both start at 1 and not 0.

answered Jun 20, 2016 at 15:33

Steve

3,0823 gold badges24 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Selaka Nanayakkara · Accepted Answer · 2019-12-07 06:50:48Z

As per the elaboration by @Darren Young Excel uses 1 based indexing thats where the issue is.

 using OfficeOpenXml; //.. ExcelWorksheet VerificationSheet_Sheet4 = package.Workbook.Worksheets.Add("SheetTitleHere"); int row = 1, col = 1; VerificationSheet_Sheet4.Cells[row + 1, col].Value = "AnyStringHere";

Collectives™ on Stack Overflow

"Column out of Range" Error when populating an Excel Sheet

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related