Completato

Note

Errore

Session expiration Your session is going to expireClick here to extend

Budget:

Piccolo progetto <800

Pubblicato il

23/04/16 23.15

Cliente

MGK***

Questo progetto è concluso

Pubblica un progetto simile e ricevi velocemente offerte non vincolanti.

Pubblica ora il tuo progetto simile

Descrizione

Write Routine in c# that does the following:

  • read the attached rota-q.xlsx
  • import all data-blocks from  rota-q.xlsx into the existing .csv-files (see attached screenshot for explanation) line by line
  • if there are lines with the same date in rota-q.xlsx and the .csv-file -> overwrite in .csv-file with the new data from rota-q.xlsx.
  • put new lines in .csv-file in the right place -> sorted by date
  • create new .csv-file if there is no corresponding one for a data-block
  • after import into .csv-file, put the date of the last imported line in Row one of the rota-q.xlsx file (see attached screenshot for explanation)
  • save/close all .csv-files and rota-q.xlsx

Routine should be compatibel with Visial Studio Express 2012.

Routine should be run from Shell (no graphical interface) usage: „imptw path1 path2“

Path1 is the path to rota-q.xlsx file. Path2 is the path to all .csv-files.

Routine should work without excel installed. If excel is needed it should be excel 2013.