Thank you Manikandan, I still have a doubt. There's the Microsoft.Office.Interop.Excel which I think is an interface to communicate between an application and Excel, and it comes with Excel and can be downloaded from Microsoft site. Also there's Office Tools which is an add-in for Visual Studio, a group of dlls, that has to be bought separately. It seems to me that it can work with Excel files and do some (or all) the operations Excel can do. Do I really need to have Excel while using that Office Tools? In case I do, I do not understand why do I need the library.
Manikandan T wrote: > hi, > > Even if you use libraries in your project. You need the EXCEL should be > installed on the machine where program is running. Instead of that you can > run this in a server where Excel is installed and Pass the text file as > arguement. After that the file is stored in the server. Then the excel can > be pulled through FTP or Network Path... > > Thanks, > Manikandan.T > > On Fri, May 27, 2011 at 11:17 PM, renatoab <[email protected]> wrote: > > > Hi > > > > I have a program written in C# that comunicates with a VBA macro in an > > Excel xls file. The macro creates a worksheet, imports data from a > > text file to that worksheet, organizes the data in the cells, makes > > some formatting, and save the new xls file. > > The problem is: this program will need to work for users that do not > > have MSExcel installed, but have OpenOffice or other similar > > softwares. > > The xls file generated can be viewed on OpenOffice and similars, but > > Excel is still needed to run the macro and generate the file. > > It seems to me that translating from the VBA macro to OpenOffice macro > > language is very complicated, because they are very different. > > I think a possible option is to translate the code to VB, VB.NET or C# > > and compile it. I know those languages can create an Excel file and do > > some operations on it. The question is: for me to have a program that > > works with xls files, written in those languages, do I need to have > > Excel installed on the computer? Or do I only need to have the > > libraries? In case it is possible, do I need to have any component > > installed on the users' computers? They are free? > > > > Thank you > > > > -- > > You received this message because you are subscribed to the Google > > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > > Web Services,.NET Remoting" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > > or visit the group website at http://megasolutions.net > > > > > > -- > T.Manikandan > 09952027660 -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
