How to Import Exel File into Stimul Soft Report?

[sadat_prog]

hi..
Please tell me How to Import Exel File into Stimul Soft Report?
Thanks for your help!!

[HighAley]

Hello.

You could create OleDB connection with one of next connection strings:

Code: Select all

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

Code: Select all

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

Thank you.

[sadat_prog]

thank you for your answer but I want to import table Design and Fields in my report .Actually I have some Tables with many fields and special design in Excel file and now I want to use them in my report without designing tables again.Is it Possible?

[Alex K.]

Hello,

Unfortunately, it is not possible.
As a way, you can try to copy the designed table from excel to word and then use our "Convert RTF (Rich Text Format) to Stimulsoft Reports" utility.

Thank you.