Read Excel file and create another file met some part of first excel file [modified]
-
Dear all, I want read Excel file and create another new Excel file with the data inside a first file. how can select a Column in a Excel file than compare this Column to another and so on, than colect this columns and create a new file from that colected columns. -- modified at 17:49 Saturday 13th January, 2007
-
Dear all, I want read Excel file and create another new Excel file with the data inside a first file. how can select a Column in a Excel file than compare this Column to another and so on, than colect this columns and create a new file from that colected columns. -- modified at 17:49 Saturday 13th January, 2007
Office applications expose a COM-based object model. If using .NET, they also include PIAs (Primary Interop Assemblies) that wrap the object model in a slightly more .NET-friendly manner. You could use this model to open, extract from, and write to Excel files. See: Excel Object Model[^] -Phil Disclaimer: I work for Microsoft as a developer on the Visual Studio Tools for Office product team.
-
Office applications expose a COM-based object model. If using .NET, they also include PIAs (Primary Interop Assemblies) that wrap the object model in a slightly more .NET-friendly manner. You could use this model to open, extract from, and write to Excel files. See: Excel Object Model[^] -Phil Disclaimer: I work for Microsoft as a developer on the Visual Studio Tools for Office product team.
Thanks Phillip