Create Excel report base on Excel Template - Taking data from an objectdatasource

[Benn]

Hi,

Before asking my company to buy a telerik product, I was wondering if Telerik has a tool allowing to generate an Excel report base on a template  file using an ObjectDataSource. Let say we have Template.xls file. I want to be able to export data into some specific cells in the Template.xls file and than save this in a temporay folder with the name ReportYYYYMMDD.xls send the file to the client side for the users to save it in his local machine.

I will need to use something like
- workbook.sheet1.cell(i,j)= xyz;
- workbook.sheet1.cell(i+1,j)= zzz

If it's possible, could you please point me that tool and show a complete code to use?

Thanks

[Steve]

Hi Benn,

It is the report itself that is the template when you export to Word (or other formats) and you cannot use an external file as base for a new report or affect the layout you've already created in a report definition.

So the answer to your question would be no, we do not offer such a tool in our suite.

Greetings,
Steve
the Telerik team

[Benn]

Hi Steve,

What you mean by its the report itself that is the template? Do you mean that you have a tool that will allow to create an Excel report template (with our logo, some colors, etc...) and use it has a template?

Benn

[Benn]

The data will be taking from an Object like dataset and this Object will be populated base on a query results.

[Steve]

Hello Benn,

What Telerik Reporting is meant for and allows you to do is use your data to bind a report. The report in its essence is a template (see Understand the Why, What and How of Reporting Solutions) that combined with your data would allow you to export it to various supported document formats. The exported Excel however would contain all the data that you see in the report and you cannot specify certain cells only.

Greetings,
Steve
the Telerik team