When am trying to display my 4th table date in 4th excel sheet. it's throwing invalid index exception

Question

0.00/5 (No votes)

See more:

Hi,

When am trying to display my 4th table date in 4th excel sheet. it's throwing invalid index exception

C#

xlWorkSheet3 = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(4);

C#

any help in solving this query.

Thanks & Regards
sam.198979

Posted 26-Jun-13 0:11am

sam.198979

Updated 26-Jun-13 0:14am

walterhevedeich

v3

Add a Solution

Comments

walterhevedeich 26-Jun-13 6:16am

If it's the 4th, shouldn't the index be 3 since you are using C#? C# indeces are zero-based.

sam.198979 26-Jun-13 6:27am

xlWorkSheet= (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(0);
xlWorkSheet1 = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
xlWorkSheet2 = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2);
xlWorkSheet3 = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(3);

it's giving same Exception

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2013-06-26T00:29:00

Solution 1

By default MS Excel stores 3 worksheets. If you want to save data into 4. worksheet, you need to add it.

How to: Add New Worksheets to Workbooks[^]
How to: Programmatically Add New Worksheets to Workbooks[^]

Posted 26-Jun-13 0:29am

Maciej Los

Comments

sam.198979 26-Jun-13 8:00am

thanks

Maciej Los 26-Jun-13 9:34am

You're welcome ;)

When am trying to display my 4th table date in 4th excel sheet. it's throwing invalid index exception

1 solution

Solution 1

Add your solution here

Preview 0

When am trying to display my 4th table date in 4th excel sheet. it's throwing invalid index exception

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us