Generate Reports in Excel without Office installed in server.

Kavitha Kundena

Hi,
I have generated the reports in excel using Msoffice but cannot generate in my server due to security issues,so..
i want to generate excel Charts without using excel.interop library.
I googled then i found all these are open source but each have its pros and cons ,NPOI ,Open Xml SDK 2.0,EPPLUS,Excellibary.

our project has about 20+ reports to generate,with different chart types.

can u please suggest me the best open source to generate reports in excel with better performance.
Urgent....
Thanks.
KK

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kavitha Kundena14y ago
ExcelChart chart = xlWorkSheet.Drawings.AddChart("Chart1", eChartType.ColumnClustered);
chart.Title.Text = "Direct Expense Efficiency Ratio";
chart.SetPosition(2, 5, 1, 4);
chart.SetSize(640, 440);
chart.Series.Add("C28:C29","B28:B29");
chart.Style = eChartStyle.Style2;

but am unable to plot the graph please review the code and attachment
please help me..
0
Kavitha Kundena14y ago
hi, Thanks for your suggestions.. know am generating excel reports using EPPLUS.
0
Kavitha Kundena14y ago
Thanks...
0
Jignesh Trivedi14y ago
Hi KK,

yes you may use Openoffice class lib. for same

Please refer...
http://opendocument4all.com/content/view/68/47/
http://www.codeproject.com/Articles/21475/TblProc-OpenOffice-Calc-and-Excel

hope this will help you.
0
George eric14y ago
If you don't want to use Interop.Excel, then I think Open XML SDK might be the best open source and free library for you. Otherwise, you have to use commercial class library.
0