Write program to convert .csv to Excel Worksheet -- 2

Annulleret Opslået 5 år siden Betalt ved levering
Annulleret Betalt ved levering

To write a program to convert .CSV file into Excel Worksheet and vice versa.

(1) From .CSV to Excel

After the conversion, some of the fields can be hidden, protected and with some calculation inside the cells ( eg. qty * price = subtotal, summary of subtotal to total )

In the sample excel file which is after conversion.

Column A,B,C will be hidden and protected

Column D,E,F, K,L,M,N will be protected

There is some calculation on particular columns and cells

(eg. I5=G5*H5, Page Total on column L, Section Total on column M etc)

Page Total will be calculated if “Page Total” found on column “E”

Section Total will be calculated if “Section Total” found on column “E”

Bill Total will be calculated if “Bill Total” found on column “E”

Job Total will be calculated if “Job Total” found on column “E”

Notes :

• The first row of the file indicate the length of characters for each column.

If the column = 0 means the column need to be hidden and protected

• The formula of column I is automatically setup during the converstion.

• The formula of Page Total, Section Total, Bill Total and Job Total are all automatically setup during the conversion.

• The First row,which used for the definition of column width, will no longer display in the output excel file.

(2) From Excel to CSV

After enter information into the Excel worksheet, those information can be converted back into .CSV as the original format.

(3) Execute as command line

• The program must be able to run as a command line program

• there is an option in the command line, which is the conversion mode,

if the conversion mode is type 1, the csv file will convert to excel as the sample file [login to view URL] file with all the specific requirements as (1), such as hidden, protect and calculation.

If conversion mode is type 2, the csv file will convert to .XLS files column by column without any special formatting but the width in terms of # of characters specified in the first row of the .CSV file.

Software Arkitektur

Projekt ID: #18785701

Om projektet

10 bud Remote projekt Aktiv 5 år siden

10 freelancere byder i gennemsnit $284 timen for dette job

mrherkar

hi there, I could develop this app, Windows .NET C#. Any good for you? Output is OpenXml XLSX file. Best

$220 HKD in 3 dage
(5 bedømmelser)
2.7
QutubHaider

Greeting Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well as it match my skills and expertise. I am having a 5+ years of experience in web dsign & d Flere

$200 HKD på 1 dag
(1 bedømmelse)
2.7
tariqs028

I will be Your PHP And Coordinator Developer. I have experience in web development designing testing and troubleshooting using latest tools and technologies Fix Issues Add Features to your website develop your new webs Flere

$80 HKD på 1 dag
(0 bedømmelser)
0.0
techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do Flere

$251 HKD in 7 dage
(3 bedømmelser)
0.0
bravo199

Hi! I work for an automotive company, and we had many problems like this. I mean, lots of data came with .csv and we need it with .xls and viceversa. All the requirements can be achived, but before start working, we s Flere

$500 HKD in 3 dage
(0 bedømmelser)
0.0
iqvalsingh28

i can deleverd in 2 days if proper requirement get I have done this before it's not take more time develop it again with your requirements

$240 HKD in 2 dage
(0 bedømmelser)
0.0
krishnadalancer

Hi, I have a very good experience in writing solid code with flexible design. I have done similar work of converting text based format to excel sheet in the recent past. I can deliver it in 3-4 days as all the req Flere

$200 HKD på 1 dag
(0 bedømmelser)
0.0