Kapalı

Extract data from Excel binary file

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.

Beceriler: C++ Programlama

Daha fazlasını görün: extract data excel binary file, extract macro excel binary file, extract binary file, winning quote, what is vba programming, what is network programming, what is embedded programming, what is a string in programming, what does binary, we excel, vba programming using excel, vba programming in excel, vba excel programming, string programming, string cplusplus, source formatting, sheets add, programming words, programming with databases, programming with data, programming in vba, programming in excel vba, programming in excel 2010, programming in excel, programming in binary

İşveren Hakkında:
( 1 değerlendirme ) Sydney, Australia

Proje NO: #741929

16 freelancer bu iş için ortalamada 2545$ teklif veriyor

creatorul

Professional solutions

in 20 gün içinde3500$ USD
(16 Değerlendirme)
6.4
simonchen

I'm Excel 97 ~ 2007 expert, please ping me if you would like to award me this project, ready to work, thanks.

in 30 gün içinde1500$ USD
(30 Değerlendirme)
6.2
poetatom

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

in 30 gün içinde3000$ USD
(3 Değerlendirme)
5.8
sentromed

Hello, I can do this. Regards, Valery.

in 34 gün içinde3200$ USD
(2 Değerlendirme)
4.7
HussienSharaf

HI, I have long C/C++ experience and i have the docs of the excel formats Hussien Sharaf

in 25 gün içinde3000$ USD
(4 Değerlendirme)
4.6
IcyStar

Ready to begin immediately

in 21 gün içinde2800$ USD
(5 Değerlendirme)
4.1
SevenStarInfo

Hello Sir, Please check PMB. Thanks & Regards, SevenStar Infotech.

in 20 gün içinde1500$ USD
(1 Değerlendirme)
4.2
gelo76

Please check PM.

in 15 gün içinde1500$ USD
(3 Değerlendirme)
4.1
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

in 10 gün içinde1500$ USD
(2 Değerlendirme)
3.3
muthusuba

Initial Bid. Please check PMB for details. Thank you.

in 30 gün içinde1500$ USD
(1 Değerlendirme)
1.4
QualiumSystems

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 fazlası

in 14 gün içinde3000$ USD
(0 Değerlendirme)
0.0
mabja

Thanks for posting in free lancer. Please see PMB

in 22 gün içinde2222$ USD
(0 Değerlendirme)
0.0
lohatama

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 fazlası

in 10 gün içinde3500$ USD
(0 Değerlendirme)
0.0
GondorTrading

We have Trained Manpower for this project , our services focusing on the customer's comfort, cost-efficiency, schedule and time keeping

in 25 gün içinde2500$ USD
(0 Değerlendirme)
0.0
perumsat

Hi, Why re-open and not use the old? Are you ready to start? Let's do it.

in 10 gün içinde4000$ USD
(1 Değerlendirme)
0.0
yangli555

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 fazlası

in 10 gün içinde2500$ USD
(0 Değerlendirme)
0.0