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.
Bu iş için 16 freelancer ortalamada $2545 teklif veriyor
I'm Excel 97 ~ 2007 expert, please ping me if you would like to award me this project, ready to work, thanks.
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
HI, I have long C/C++ experience and i have the docs of the excel formats Hussien Sharaf
Hello Sir, Please check PMB. Thanks & Regards, SevenStar Infotech.
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
Dear Client, Qualium-Systems is software development company located in Ukraine. We have strong C++ team which is able to work at your application. Please check PMB for more details. Our current BID is place-ho Daha Fazla
I already have the module for that. Written in C++. This will need a special handler if we talk about VBA. As it needs to use VBA Projects storage where the documentation is very minimal. But, I have it wrapped well in Daha Fazla
We have Trained Manpower for this project , our services focusing on the customer's comfort, cost-efficiency, schedule and time keeping
Hi, Why re-open and not use the old? Are you ready to start? Let's do it.
I am an expert C++ programmer. I have worked at Bloomberg and other places for more than 9 years. I am starting my own business while working as a freelancer now. I will deliver stylish, professionally designed, w Daha Fazla