We are looking for someone that can extract information from an .xls, .xlsx and xlsm binary file format to determine the following:
1> list all external links from the file to other files (name, location and type)
2> list all web queries in the file (name, location and query detination)
3> list all pivot tables in the file (name & location)
The output data is to be written to a sqlite database where the location of the database is configurable.
This is to be achieved without opening an instance of the file that is being tested. That is, it is to be achieved by reading the binary format of the file only.
The dll will have an API to enable it to be run by another program that will scan multiple files on a network.
We would require the source code as well as the compiled dll.
16 freelancer bu iş için ortalamada 1816$ teklif veriyor
I can make make universal software for this task. Read from all structured sources (Office files as well, ODBC source and other) and parse/exctract information what you need.