The objective is to populate a predefined Excel workbook from an external data source. The data source will provide the names to save the populated workbooks under and the data that will be copied to the workbooks. Formats and formulas must be copied or applied as each row is added in the template.
In the current case, the external data source will be an excel workbook with 4 worksheets.
The first column in each worksheet will hold the name of the final saved workbook to which the data will belong.
The Template workbook has a number of worksheets. Some contain settings that and will not need to be impacted. Only the 4 corresponding worksheets in the Template will be updated.
The resulting excel files are usable versions with frozen columns, worksheet protection enabled, etc. all derived from the Excel template.
Development is for a desktop application built using Visual studio 2008. Prefer C#, VB is OK.
• Allow the selection of the Excel Template and Data source file
• Allow selection of the destination folder for the created excel workbooks
• No security or login requirement
• Settings, formats, protection, etc. of cells must be preserved as new rows are added in the column
42 freelancers are bidding on average $344 for this job
I have very good experience in excel automation using c#. I did csv file compare and generated a excel sheet with the difference by giving each cell with a background color. Hoping for positive response.