How to Registering an EXCEL Data for the Report Template?

[suntianyong]

How to Registering an EXCEL Data for the Report Template?

[Max Shamanov]

Hello,

Please check the following link.
How to create datasource based on Excel data.
https://www.stimulsoft.com/en/documenta ... g_data.htm

Thank you.

[suntianyong]

how t to use javascript code registering an excel data Sources for the Report Template?

[Max Shamanov]

Hello,

You can use the following code:

Code: Select all

report.dictionary.databases.add(new Stimulsoft.Report.Dictionary.StiExcelDatabase("excel", "/TestApp/Data/Book1.xlsx"));
            var table = new Stimulsoft.Report.Dictionary.StiDataTableSource("excel.Sheet1", "table1");
            var column1 = new Stimulsoft.Report.Dictionary.StiDataColumn("Id", "Id", "Id", String)
            table.columns.add(column1);
            report.dictionary.dataSources.add(table);

Thank you.