I just wanted to point out that, a couple months ago, I ported the excellent Java library JExcel from Java to native dotNet. I ran into a problem where the 64-bit IIS servers at work did not like the J# (32-bit only) option of compiling JExcel for use with .NET projects. My boss gave me latitude and permitted me the time to do this port.
If you are looking for a convenient way to create Excel spreadsheets or to parse data out of incoming spreadsheets in .NET, let me recommend this product. No, I am not biased. I have used this in its Java incarnation and recompiled with J# for at least 7 years or so and have been impressed with it. The beauty of the library is that Excel does not have to be anywhere near the machine that executes the code to create or read the spreadsheets! Andy Khan, the original developer, did a marvelous job and made many a programmer’s life much easier….
Anyway, the link to the project is: jexcelapi.sourceforge.net and clicking on the Files link will take you to the download area where you can get the Java and C# versions with full source. There is documentation for the Java version which also describes (mostly) the .NET version since the method names are (mostly, with a couple notable exceptions) the same.
Enjoy!
Like this:
Like Loading...
About claforet
I have been photographing since my college days. My current gear is a Nikon D-700 along with a plethora of lenses, and always tote an Olympus point-and-shoot digital camera attached to my hip.
My first serious camera was a Canon EF back in the early 80s. A Canon A-1 soon followed. Since then, I also have had a Minolta Maxxum, Nikon FM, Nikon F4, and Nikon Point and Shoot in my film days. I have had and maintained a private full color and B&W lab on and off for much of that time. My photos can be found at http://www.flickr.com/photos/claforet
Photography and painting are my "sanity breaks" that save me from my day-to-day software development existence! I host a group in Facebook called "Painting as a Second Language" for anyone who is interested in painting as an outlet for the day-to-day pressures. Please look it up and join if you think it will meet your needs.
Recently, I have also branched into the video world and am learning how to shoot video better and how to edit compelling video sequences. My learning experiences will be part of this blog and my videos can be seen at http://www.vimeo.com/claforet
I live in, and photograph mostly around, North Carolina. I love traveling so there are many shots from states around us, out West, and other places. My daughter has been bitten by the photography bug too. She has spent time in a B&W lab and loves the excitement generated by just the smell of the chemicals. Maybe one day she will take over where I leave off....
Pingback: Chris’ Creative Musings: 2010 in review | Chris' Creative Musings
Hi Chris – Do you provide advice/support?
I can’t get the GridLines to print and show.
SheetSettings settings = new SheetSettings(s);
settings.setPrintGridLines(true);
settings.setShowGridLines(true);
Thanks,
Tom
Since you posted this a while back, I assume you pulled the code and traced it and it is no longer an issue.
I couldn’t figure it out quickly enough, for some reason.
I ended up using NPOI v 1.2.3.
NPOI 1.2.4 has a new bug in it when saving workbooks containing multiple sheets.
Merry Christmas and God Bless,
Tom