Software Development

Our organization (blindness non-profit in California) is obligated to submit reports to grant organizations (e.g., Department of Rehabilitation) on a regular basis. Most of the time, this means exporting data from our case management system and copying it manually into an Excel template file containing several worksheets provided by the grant organizations. Data validation rules, summaries, etc. are all implemented with Excel functions; basically, the Excel files are treated as databases (I know, blasphemy).

I'm looking for projects written in general programming languages (so VBA is not an option) to automate this process of filling out the reports - or, when the provided Excel templates are protected and the org is not willing to accommodate this use case, to re-create them from scratch with the existing functionality.

is a duplicate

This question has been asked before and has already been answered. It should be marked as a duplicate.

Please enter the URL of the proposed duplicate in the details field below.

not constructive

This question cannot be answered in a way that is helpful to anyone. It's not possible to learn something from possible answers, except for the solution for the specific problem of the asker.

Communities

Comments on How to create and manipulate (read/write) Excel (XLSX) documents with complex rules using general programming languages?

How to create and manipulate (read/write) Excel (XLSX) documents with complex rules using general programming languages?

1 comment thread