Comments on Leniel Macaferi's blog: Creating Excel spreadsheets .XLS and .XLSX in C#

what i did was made the reference to the several d...

2012-01-10T20:14:56.980-02:00

what i did was made the reference to the several dll's

then using
HSSFWorkbook templateWorkbook = new HSSFWorkbook()
results in an internal error.
I don't know if IOS5 is responsible for this. The dll's are from 2009

Hi Richard, From what I could read at Mono Touch ...

2012-01-10T17:53:39.595-02:00

Hi Richard,

From what I could read at Mono Touch website: http://xamarin.com/monotouch you should be able to use existing .NET code in your projects.

Reuse existing code

Import existing .NET libraries and use them in your
MonoTouch apps. Easily bind existing C and Objective-C libraries as well.

I don't know about anyone that has already used NPOI with Mono Touch apps but given the lines above it appears that NPOI can be easily integrated... just give it a try and tell us here if it really works as expected.

I would like to use this with monotouch and IOS5. ...

2012-01-10T07:12:49.987-02:00

I would like to use this with monotouch and IOS5. Does this support IOS5 ?

Hi sandepku, As the post shows, NPOI does XLS an...

2012-01-06T01:38:28.118-02:00

Hi sandepku,

As the post shows, NPOI does XLS and not XLSX. ExcelPackage does XLSX.

NPOI is really fast as far as I can tell you.

All the best.

Hi Leniel, can we use NPOI to read data from xls a...

2012-01-04T08:58:57.036-02:00

Hi Leniel, can we use NPOI to read data from xls as well as xlsx files ? or its only xls ? I am having a tough time with COM, will npoin solve my problem of needing a faster access. pls help thanks
Sandepku

Hi Etienne, I've forwarded your question to T...

2011-12-22T12:52:11.924-02:00

Hi Etienne,

I've forwarded your question to Tony Qu ( the guy responsible for NPOI development ) since I haven't used NPOI for this purpose.

This is the answer he has sent me:

"No. I suggest him use some third-party CSV solution. CSV is much
easier than XLS formats. However, if NPOI supported CSV, what if they set
CellStyle and saved as CSV. What should NPOI do? Throw exception? In
Excel UI, it will warn you that some style will be lost. That's the main
concern and why I don't want NPOI to support CSV."All the best,Leniel

Hi, Can we use NPOI to save Excel in CSV format?

2011-12-21T14:42:20.976-02:00

Hi,
Can we use NPOI to save Excel in CSV format?

Excellent article and thanks for pointing me in th...

2011-11-21T11:03:41.684-02:00

Excellent article and thanks for pointing me in the direction of NPOI.

Awesome article. I use NPOI but this looks like a...

2011-08-25T13:15:06.054-03:00

Awesome article. I use NPOI but this looks like a great example of how to save using templates. Thx.

Hi, Please be aware that NPOI uses Apache licence...

2011-08-05T12:23:12.115-03:00

Hi,

Please be aware that NPOI uses Apache licence and ExcelPackage uses GPL licence. In other words, NPOI can be used in commercial software adn ExcelPackage cannot.

Cheers,

James

Hi Nelson, Thanks for letting me know that link n...

2011-04-11T11:46:53.910-03:00

Hi Nelson,

Thanks for letting me know that link no longer works.

It's giving a 404 error: The URL you have requested could not be found. (404)

The problem is because Google renamed the service called Google Pages to Google Sites. There was a redirect system in action that pointed all my files from Google Pages to this new Google Sites place. It seems the redirect system stopped working.

I'm updating the post with the new link. Check it.

Regards,

Leniel

Hi all, Could somebody post a mirror of the origin...

2011-04-11T10:39:14.929-03:00

Hi all,
Could somebody post a mirror of the original project?
Apparently, the file
http://leniel.googlepages.com/ExcelWriterMvcProject.zip
has been deleted :(
thx in advance
and great article btw.

GrSP, First off, sorry for taking so long to answ...

2010-12-27T12:11:55.623-02:00

GrSP,

First off, sorry for taking so long to answer your comment.

I haven't tried to work with cell comments yet.

The advice I can give you is:

Search for this problem and then if don't find anything related, open a thread at the Issue Tracker or Discussions page at the NPOI project page:

Issue Tracker:
http://npoi.codeplex.com/workitem/list/basic

Discussions:
http://npoi.codeplex.com/discussions

Hope this helps,

Leniel

Yeddy, Your best bet is this post: NPOI with Excel Table and dynamic Chart.

This is a workaround to overcome a current limitation of NPOI.

Hope it helps,

Leniel

Hi Mr Leniel, My question is similar to the first...

2010-12-08T02:48:32.224-02:00

Hi Mr Leniel,

My question is similar to the first comments. How do I attach new row using NPOI ? Lets say :
row 1 = report title
row 2 = start report table
If I want to attach new row between row 1 and 2, what do I have to do? I tried Sheet.CreateRow, but unfortunately row 2 is not automatically became row 3, the new row replaced to row 3 itself...please help me

many thanks in advance

YD

Hi Spenser, Based on your description, it's d...

2010-09-19T23:16:13.885-03:00

Hi Spenser,

Based on your description, it's difficult to tell what data you have in the database.

Questions I have:

1 - How is your database table designed? What columns does your table have? What is the type of each column?

2 - Each row of the database table would be mapped to an instance of this class?

If I cannot answer your question here, feel free to ask it at StackOverflow - http://stackoverflow.com/

StackOverflow: best place to share/learn programming

A number of these objects are IDisposable (HSSFWor...

2010-09-13T16:09:15.895-03:00

A number of these objects are IDisposable (HSSFWorkbook, HSSFSheet, streams). You might want to wrap these in using blocks to insure that resources are cleaned up immediately.

Hi Leniel, This is a very helpful post. I have a...

2010-09-11T10:58:17.402-03:00

Hi Leniel,

This is a very helpful post. I have a quick question, though, that I thought you might be able to help me with. In order to populate the .xls file, I would like to create a Class with the following members:

* Name: The name of the field used in the database. This is a STRING.

* Description: Description of the field which will appear in the Excel file next to the field itself. This is also a STRING

* DataType: The type of data contained in the field (for example, int, string, decimal, etc.). Question: what type should this member be declared as?

* Contents: The contents of the field. Should be declared with the data type specified in DataType above. Question: is it possible to declare a member with a type specified by another member?

* Row: INTEGER containing the row number of the field

* Column: INTEGER containing the column number of the field

Is it possible to create the DataType and Contents members as I have described above in C#?

Many thanks in advance for your help.

Jason, Take a look at the project named SetDateCe...

2010-07-09T12:54:35.328-03:00

Jason,

Take a look at the project named SetDateCellInXls that is part of NPOI Examples package - http://npoi.codeplex.com/releases/view/19351#DownloadId=70100

Here goes the code:

HSSFSheet sheet = hssfworkbook.CreateSheet("new sheet");

// Create a row and put some cells in it. Rows are 0 based.
HSSFRow row = sheet.CreateRow(0);

// Create a cell and put a date value in it. The first cell is not styled as a date.
HSSFCell cell = row.CreateCell(0);
cell.SetCellValue(DateTime.Now);

// Style the second cell as a date (and time). It is important to Create a new cell style from the workbook
// otherwise you can end up modifying the built in style and effecting not only this cell but other cells.
HSSFCellStyle cellStyle = hssfworkbook.CreateCellStyle();
cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("m/d/yy h:mm");
cell.CellStyle=cellStyle;

//set chinese date format
HSSFCell cell2 = row.CreateCell(1);
cell2.SetCellValue(new DateTime(2008, 5, 5));
HSSFCellStyle cellStyle2 = hssfworkbook.CreateCellStyle();
HSSFDataFormat format = hssfworkbook.CreateDataFormat();
cellStyle2.DataFormat = format.GetFormat("yyyy年m月d日");
cell2.CellStyle = cellStyle2;

Hope this helps.

Unfortunatey that isn't an option. This is an...

2010-07-09T12:27:18.260-03:00

Unfortunatey that isn't an option. This is an export of a dynamic data grid so the columns can be different everytime.

I tried writing my own setcellformat method in the hssfdataformatter that sets the format index of a cell's cellstyle.

unfortunately that applied the format to all cells deriving that style. If I change my code so taht it creates a new style for that cell and applies that format to the new style, should that fix my issue?

Jason, Create an Excel template that has the numb...

2010-07-09T11:16:37.267-03:00

Jason,

Create an Excel template that has the number of columns/formats that you need.

For the DateTime column, still inside Excel select the entire column and right click it. Select Format Cells... (I'm using Excel 2010 here) then select Date as the default for that column. Save this Excel template and reference it the way I show in this post.

Using this template you should be able to fill it correctly, that is, when you insert data on the DateTime column, you'll see the correct values shown in the Date format you've chosen.

Note: it's obvious that the data you're inserting in this column should be a DateTime.

Leniel - I hope you can help with this. I need ...

2010-07-09T10:55:27.786-03:00

Leniel -

I hope you can help with this. I need to force a value format for a date column when I create my excel document. For some reason, when I open the document up in excel, it still displays the date as the double value that NPOI translated it too and not as a datetime.

How can I set a value format for that cell when I create the document?

Thanks!

Leniel, I hope you might be able to steer me in t...

2010-07-09T10:50:27.222-03:00

Leniel,

I hope you might be able to steer me in the correct direction on my issue.

I am using NPOI to export data for my users from another application. When my users open up the document, all of the datetimes display as doubles. How can I assign a datetime value format to the cell so that it will be interpreted correctly as a datetime when excel opens instead of being displayed as a double which is confusing my users.

Hi, I am using NPOI to work with excel files. I op...

2010-04-28T02:46:49.709-03:00

Hi,
I am using NPOI to work with excel files. I open a .xls file and want to add a comment to a cell. When I create a new sheet and create a row and cell, then add comment to cell, it works truly(according to SetCellComment sample). But when I add comment to a cell in a sheet that contains comment or chart or picture does not work. It is assigned in debug mode to CellComment, but when save to a file the comment does not exist. Can you help me?
Thanks a lot

Hi Greg, You're welcome. This post may be of...

2010-04-26T19:36:48.705-03:00

Hi Greg,

You're welcome.

This post may be of some help:

NPOI with Excel Table and dynamic Chart

All the best,

Leniel Macaferi