USING EXCEL SHEET INSTEAD REPORT IN WINDOWS APPICATION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,SIR
I WANT TO USE AN EXCEL SHEET INSTEAD REPORT WHENEVER I CLICK GENERATE
EXCEL REPORT BUTTON SO THAT USER CAN SEE THE DATA IN EXCEL SHEET AND SAVE IT
AND PRINT ALSO.IS THERE IS A NY WAY TO GENERATE EXCEL SHEET AS I CLICK A
BUTTON LIKE REPORT ?, IF YES PLEASE GIVE ME.
 
Hi,

You can either use Excel OLE automation to generate a sheet
programmatically, or you can use a 3rd party solution capable of generating
reports in Excel.
 
Hello NITIN,

Dmitriy is right. As for some third party reporting solution, I'd recommend
to go and check Report Sharp-Shooter by 9Rays.Net. They offer 13 export
filters and among them export to Excel, and Excel (XML). Report
Sharp-Shooter is a very flexible and inexpensive solution. I use it myself
and like it a lot. Try: http://www.9rays.net
If you have questions, please ask

Good luck,

Will
 
Be careful with Excel 2003 and VS2003, you need to re-compile the
Excel OLE object in order to access the Excels sheet's events
correctly:
http://support.microsoft.com/default.aspx?scid=kb;en-us;823981

Hope this helps

OracleVsMicrosoft

http://OracleVsMicrosoft.blogspot.com


Hi,

You can either use Excel OLE automation to generate a sheet
programmatically, or you can use a 3rd party solution capable of generating
reports in Excel.

--
Sincerely,
Dmitriy Lapshin [C# / .NET MVP]
Bring the power of unit testing to the VS .NET IDE today!
http://www.x-unity.net/teststudio.aspx

HI,SIR
I WANT TO USE AN EXCEL SHEET INSTEAD REPORT WHENEVER I CLICK GENERATE
EXCEL REPORT BUTTON SO THAT USER CAN SEE THE DATA IN EXCEL SHEET AND SAVE
IT
AND PRINT ALSO.IS THERE IS A NY WAY TO GENERATE EXCEL SHEET AS I CLICK A
BUTTON LIKE REPORT ?, IF YES PLEASE GIVE ME.
Click to expand...
Click to expand...
 
Back
Top