Automatically analyze excel files

Posted by dole doug on Programmers See other posts from Programmers or by dole doug
Published on 2014-05-26T10:35:42Z Indexed on 2014/05/27 9:54 UTC
Read the original article Hit count: 355

Filed under:

problem-solving

|

automation

|

excel

I have to replicate a manual generation of a large number of excel files. I started to manually track the relations between cells ( files, formulas, etc). I also had a talk with the person which generates those files. For now I have a general understanding about how the excel files are generated, but "devil is in the details".

I assume that I can write a script which will generate the hierarchy between cells and files, but this might require the same effort as manually noticing the relations. Also, I'm afraid that I'm not too experienced and my app is more prone to error approach than a manual analyze.

How to handle this problem? Do you know about an open source project which analyze the excel files in a recursive mode following the formulas ?

© Programmers or respective owner

Related posts about problem-solving

problem solving [closed]

as seen on Stack Overflow - Search for 'Stack Overflow'
Problem Statement The Sports Associations in India (SAI) wants to choose 2 teams of 4 people each to send to Asian games. There are 13 people who want to be members of the teams. The SAI tries grouping them in various ways to see which athletes perform well together. Each grouping gets one test… >>> More
How do one improve him/her problem-solving ability ?

as seen on Programmers - Search for 'Programmers'
How can one improve him/her problem-solving ability? Every one says same thing "a real programmer knows how to handle real problem", but they forget how they learn this ability, or where (I know in school, no one gives us any ability, of course in my opinion). If you have any idea except above… >>> More
How does one improve one's problem-solving ability?

as seen on Programmers - Search for 'Programmers'
How can one improve one's problem-solving ability? Everyone says same thing: "a real programmer knows how to handle real problem." But they forget how they learn this ability, or where (I know in school, no one gives us any ability, of course in my opinion). If you have any idea except above ones… >>> More
ASP.NET/VB.NET problem solving help!

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi folks, Got a problem I need help with. Basically I'm gonna develop a form (part of a bigger web app) that lists a load of clients and there business contact, tech contact 1, and tech contact 2. The idea is rapid data entry. So one form shows each client with their contacts in dropdowns and I… >>> More
Problem solving-pascal

as seen on Stack Overflow - Search for 'Stack Overflow'
Salutations, Need some help writing this; a pseudocode that accepts as input the name and sections(160, 220, 280, 350, 425) of a masquerader, continue to run until a blank name is input. After that, pseudocode should process the amount the masquerader pay.Then pseudocode code output masqueraders… >>> More

Related posts about automation

Documenting applications - automation / semi-automation for screenshots?

as seen on Stack Overflow - Search for 'Stack Overflow'
For me one of the biggest bores of being a developer is writing user documentation. (I am referring to the stuff that gets exported into PDF files files that ship with the product, not comments in code here). The task off adding or updating new bits of text to the existing documentation is OK. However… >>> More
Why the cucumber features keeps running even though it fails?

as seen on Stack Overflow - Search for 'Stack Overflow'
Its a rails 2.3.5 app. I'm using the rspec and cucumber for testing. When I run autospec, it runs correctly with the warning (Not running features. To run features in autotest, set AUTOFEATURE=true.) as below: [~/rails_apps/automation (campaign)?] ? autospec (Not running features. To run features… >>> More
Automation testing tool for Regression testing of desktop application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am working on a desktop application which uses Infragistic grids. We need to automate the regression tests for same. QTP alone does not support this, we need to buy new plug in for same which my company is not very much interested in. Do we have any open source tool for automating regression… >>> More
automation of data format conversion to parent child format

as seen on Stack Overflow - Search for 'Stack Overflow'
This is an excel sheet which has only a single column filled for each row. (explanation : all CITY categories fall under V21 , all handset categories fall under CityJ and so on ) V21 CITYR CITYJ HandsetS HandsetHW HandsetHA … >>> More
Automation: how to automate transforming .doc to .docx?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a bunch of .doc files in a folder which I need to convert to .docx. To manually convert the .doc to .docx is pretty simple: Open .doc in Word 2007 Click on Save As... Save it as .docx However, doing this for hundreds of files definitely ain't fun. =p How would you automate this? >>> More