problem excell ListObjects.Create

[ict@sogedin.it]

Hi I've two sheet and I want insert
sheet.ListObject in sheet 0 and sheet 1

for (int i = 0; i < 2; i++)
{
sheet = book.Worksheets[i];
sheet.InsertDataTable(tbUltima, true, _riga + 1, 1);
sheet.ListObjects.Create(_tabella, sheet.Range[_riga +1, 1, sheet.LastRow, sheet.LastColumn]);

}
but when i open the file is error
viwe file attachments

[Nina.Tang]

Hello,

Thanks for your inquiry.
Kindly note the name of ListObjects should be different in each loop, please make sure the _tabella in your code is a variable. If you were using an older version, I suggest first downloading our latest Spire.XLS Pack(Hotfix) Version:8.3.5, and then using below code to have a try. If the issue still happens, please provide your input excel file and full code to help us do further investigations.

Code: Select all

sheet.ListObjects.Create("test"+i, sheet.Range[5, 1, sheet.LastRow, sheet.LastColumn]);

Sincerely,
Nina
E-iceblue support team

[ict@sogedin.it]

Hi buy the spire.office
i read the Version 7.10.81.4041 for Identity Spire.XLS
where I can download last release of Spire ??

[Nina.Tang]

Hi,

The download link of latest Spire.Office is Spire.Office Platinum (DLL Only) Version:2.16.27. Please have a try.

Sincerely,
Nina
E-iceblue support team

[ict@sogedin.it]

Thans, now is correct

[Nina.Tang]

Hi,

Glad to hear that.
Just feel free to contact us if you need any assistance.
Wish you all the best!

Sincerely,
Nina
E-iceblue support team