Can anyone suggest me an approach to retrieve the excel file details (Alternative of Interop)?
I want to track user working excel file details (like workbook name, sheet name, formula present in the sheet/workbook, Macro value.)
Asked
Active
Viewed 138 times
1 Answers
0
If the Excel file is an OpenXML file (XLSX or similar extensions), you could simply read it using Packaging in .NET. You have to extract all data yourself then, which is quite some work. You could use the DocumentFormat.OpenXml to make reading a little easier.
Another option is to use EPPlus, which effectively does the same, but saves you a lot of work.
Patrick Hofman
- 153,850
- 22
- 249
- 325
-
Hi , For EPPPlus we have to pass the filepath or memorystream of excel file then only we can retrieve the excel file data.Here In my application I am using Foregroundwindow API to capture the handle of active excel workbook and using handle ID I would like to retrieve the excel data.. – Meenakshi K Mar 11 '15 at 07:02
-
Can u suggest approach, by giving handle value to retrieve the excel file data.... – Meenakshi K Mar 11 '15 at 07:03
-
As far as I know there are no tools to do so. – Patrick Hofman Mar 11 '15 at 07:08
-
Other than Interop approach , do we have any methodology to capture excel data behind the screen without affecting running excel application. – Meenakshi K Mar 11 '15 at 07:12
-
@user3520395: Anything more I can do for you? If not, please accept the answer. – Patrick Hofman Mar 11 '15 at 08:00
-
It does answer your question exactly. – Patrick Hofman Mar 11 '15 at 13:01