Questions about Tables

Aspose.Cells Product Family
1

Hi Everyone,

I have two questions:

1. ////////////////////////////////////////////////////////////////////////////////////////////////
I noticed a bug in the GetNamedRangesAndTables(), please find enclose “bug1.xlsx”. Here is the situation: I have one table on the first sheet and one table on the second sheet.

// I open my report
Workbook modele = new Workbook( “C:\somewhere\bug1.xlsx” );
Range[] test = modele.Worksheets.GetNamedRangesAndTables();

And I got an ArgumentOutOfRangeException. Could you guys try to fix that ?

2. ////////////////////////////////////////////////////////////////////////////////////////////////
I use the ListObjects method to fetch some excel tables. It works pretty fine but I wonder if it was possible to get all the tables of all the worksheets:

Actually I do:
ListObjectCollection tables0 = wb.Worksheets[0].ListObjects;
ListObjectCollection tables1 = wb.Worksheets[1].ListObjects;
…

What I would like to do is:
ListObjectCollection tables = wb.Worksheets.ListObjects; // (in order to have all the tables)

Is it possible and if yes, how ?


Thanks in advance,

Best Regards,
Louis.






2

Hi,

Please try this download Aspose.Cells for .NET 5.3.3.4. We have fixed the issue of GetNamedRangesAndTables(). For your other question, we will update you soon.

3

Hi,


Regarding your other question.
If you want to get the all listobject in the workbook, you have to get them from each worksheet. Exactly the way you are doing it right now.
4

Mshakeel Faiz > Thanks for fixing the issue !
Babar Raza > Ok I will do so.

Thanks for the answer,

Best Regards,
Louis.