Questions tagged as 'npoi'

I'm using the NPOI library to be able to generate an Excel file. This is the first time I've been in touch with this library and would like help putting background color on the cells in the first row. My current code is this: using Syste...

I would like to read an Excel worksheet (XLS and XLSX) in my C # application, using the NPOI library and generating a DataTable. Since I have never used this library, could anyone give me a practical example?     

I'm trying to create a line in an excel file through the NPOI library. The problem is that I do not know how to set a size for the line. Currently, the line is capping the content of the text. How can I set the height of the line (if possib...