2

Which dll or library can be used to create the excelsheet which is not of a particular format such that a template can be used in this context. While the rows and columns may be merged. Number of columns are not fixed.

For example: In the first row column 1 and 2 are merged while in the second row the 2 rows of second column are merged. Say first row is containing 5 columns while the second row is of 4 columns.

Interop is not desired as the system running the program may not have Microsoft office installed with it.

Any suggestions would be a great helping.

Vinay
  • 471
  • 3
  • 8
  • 19

1 Answers1

5

There are several options out there (free and commercial):

Another option (though not really recommended) is to generate a HTML file with specific tags - supported by Excel as per MS documentation http://msdn.microsoft.com/en-us/library/Aa155477%28office.10%29.aspx . For a sample of this including source code see http://www.c-sharpcorner.com/UploadFile/kaushikborah28/79Nick08302007171404PM/79Nick.aspx

Yahia
  • 69,653
  • 9
  • 115
  • 144
  • Thanks @Yahia for the links. I would surely notify you as soon I could find which one suits well to my working. – Vinay Oct 10 '11 at 12:50
  • you are welcome - please don't forget to upvote/mark as accepted any answers that are of help... – Yahia Oct 10 '11 at 12:58
  • I know it really late to reply, but it helped me a lot. I did used NPOI for the same :) Thanks – Vinay Nov 21 '12 at 11:38