excel format

djkno3

I was wondering if I made a little app, if I could save the resulting file as an excel file. I searched the articles and found out you can do it through asp .net but I want just a winforms app to do it. What I want to do is either make an app that appends information to an exsisting excel file. Or info on how to make an office addin to take a file and merge it to the currently open file. Any help would be great (heck even some concisive links on information would be nice, not just www.msdn.microsoft.com)

Ista

Well actuall the best tool for this is ExcelWriter by Artisan It does all the encoding and formatting. Of course you can create a plain csv file also but excel writer is awesome for the web and winforms. This tool is a com and they might have a .net version but I doubt. But it really doesnt matter. nick I'm not an expert yet, but I play one at work. Yeah and here too.

djkno3

I was looking to make one myself (perferably not asp .net, one to work with winforms) but thanks for the link.

Ista

Well then open an excel file binarily because you have formatting at the beginning. And really is it worth the development time? I'm not an expert yet, but I play one at work. Yeah and here too.

djkno3

For me yes, it's just a little somthing a friend asked me to do for him so there is no real budget for it.

Stephane Rodriguez

You have a number of options available to you : - use Excel automation. After all, that's what it is for. Of course, this supposes the machine executing your code has Excel installed on it. To know the automation code, just record an Excel macro and translate the resulting VB code into C#. Simple and fast. - Use ODBC / Excel and create a query that writes to a .xls file - translate this tiny and fast code[^] into C#. (If you do so, remember to share it on CodeProject).

RSS feed