Page 1 of 1
How to Import Exel File into Stimul Soft Report?
Posted: Mon Nov 05, 2012 7:28 am
by sadat_prog
hi..
Please tell me How to Import Exel File into Stimul Soft Report?
Thanks for your help!!
Re: How to Import Exel File into Stimul Soft Report?
Posted: Mon Nov 05, 2012 10:20 am
by 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.
Re: How to Import Exel File into Stimul Soft Report?
Posted: Tue Nov 06, 2012 4:51 am
by 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?
Re: How to Import Exel File into Stimul Soft Report?
Posted: Tue Nov 06, 2012 10:33 am
by 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.