none
Export to Excel using C# code [XML Spreadsheet Reference] RRS feed

  • General discussion

  • Hello Support,

    I'm generating Excel file using "XML Spreadsheet Reference" using https://msdn.microsoft.com/en-us/library/aa140066%28v=office.10%29.aspx#odc_xmlss_contents this link... Everything is working fine.

    I want to export 10-20 tables on same sheet, but as per description below I can only manage one table each sheet.

    "

    Defines the cell table within the current worksheet. In this version 
    of the schema, only one instance of a Table tag is valid for a single 
    worksheet.

    "

    Can you please let me know how to create/Draw multiple tables using these tags/method?

    Note: As we knew there are several methods by which can generate the Excel file using C# code, but I want to export 5 tables on each sheet and my report also having multiple sheets, and I'm not finding any proper solution for same.

    Wednesday, December 16, 2015 10:10 AM