We are looking for someone that can extract information from an .Excel workbook files to extract the information listed below. That is, we require the information to be extracted from Excel workbooks that have been created by versions of Excel from Excel 97 to Excel 2007.
The output data is to be written to an Sqlite database.
This is to be achieved without opening an instance of the file that is being tested with Excel itself. That is, it is to be achieved by reading the binary format of the file only. Each of the data elements to be discovered needs to be optional (other than the first 10 in the list below)
The dll will have an API to enable it to be run by another program that will scan multiple files on a network to extract this information from each file.
We would require the application to be written in C++ and the source code is to be delivered as well as the compiled dll.
Information to be extracted from each workbook (S/S)
1. List S/S name
2. List S/S file date on server
3. Excel date Created
4. Excel date Modified
5. Excel date Accessed
6. List S/S size
7. List S/S location (using UNC)
8. List S/S Author
9. What version of Excel was used to create it
10. List the owner of the S/S
11. List the number of sheets in the workbook
12. How many hidden sheets. List names
13. How many very hidden sheets. List names
14. Worksheet, cell reference and name of any cells that contain “#Value”, “#Name”, “#Ref”, “#Div/0”, “#N/A”, “#NULL” or “#NUM”
15. Determine if the S/S has any Add-Ins associated with the sheet and if it does, what the name of the add-in(s) are.
16. List all external workbook links. We need the name of the worksheet and the cell that contains the link, and the name of the workbook, worksheet and cell reference that each link refers to. If links are embedded in a formula we need to be able to list all the links in the formula for each cell.
17. List all external database and other application links from cells
18. List all circular references
19. List worksheet and cell address of all cells displaying a number that is actually a text string.
20. List worksheet and cell address of all cells with formulas that contain constants
21. List worksheet and cells address of all cells with conditional formatting
22. Does the S/S have any VBA or C# code associated with it? If so, how many lines of code and how many modules. Are there any external links to other workbooks or databases in the code? Are there any connections to databases or applications? If so we need a list of the names and locations of the databases or applications. Does any of the VBA modules have the comment “Macro recorded on xx/yy/zzzz” (in other words, was the macro created by Excel’s record function?)
23. List location of all pivot-tables. Worksheet and cell reference (range) and table name
24. List location of all web links. Name, Worksheet and cell reference
Apologies to previous bidders for the freezing of this project. We did not manage to complete selection in the time allowed. This was due to changing specifications. The specifications will not be changed again prior to selecting a winning bibber and the winner of this project will most likely be asked to quote on other similar work in the future.
16 freelancer bu iş için ortalamada 2545$ teklif veriyor
Dear Sir, I have all necessary documents for the Excel binary format and 22 yrs experience of Windows programming. Please let me do this job for you. Best regards, Poetatom