Include pre-built excel template file to be saved to disk during install RRS feed

  • Question

  • Hello,

    I am currently working on a small project for work and am fairly new to c#.

    The main goal for this program is to automaticly update our KPI Dashboard; which is an Excel template file.

    The CSV files are the source data for the VLOOKUPS and Pivot Tables / Charts.

    I have the main function of the program working, which allows for the user to

    1. Browse for the downloaded CSV files.
    2. Renames and moves the selected CSV to specified dir
    3. checks if file name exists and if it does renames the old file to the previous(day,month,year) depending on the dir selected

    What I want to do is include the Dashboard Template file in the installer, so when the program is installed it is saved to C:\dashboard\views or any specified DIR.

    Allowing for a Step 4.

    • Click button and launch excel with the updated dashboard

    Basically allowing me to give the program to any of our managers and them not need any external files.

    What is the best way for going about this?


    Sunday, August 18, 2019 8:50 PM

All replies