Generate Reports in Excel without Office installed in server.

Question

Hi I have generated the reports in excel using Msoffice but cannot generate in my server due to security issuesso.. 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.0EPPLUSExcellibary. our project has about 20+ reports to generatewith different chart types. can u please suggest me the best open source to generate reports in excel with better performance. Urgent.... Thanks. KK

Kavitha Kundena · Answer

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:C29B28:B29); chart.Style = eChartStyle.Style2; but am unable to plot the graph please review the code and attachment please help me..

Kavitha Kundena · Answer

hi Thanks for your suggestions.. know am generating excel reports using EPPLUS.

Kavitha Kundena · Answer

Thanks...

Jignesh Trivedi · Answer

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.

George eric · Answer

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.