Write program to convert .csv to Excel Worksheet -- 2
$80-240 HKD
Paid on delivery
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.
Project ID: #18785701
About the project
10 freelancers are bidding on average $284 for this job
hi there, I could develop this app, Windows .NET C#. Any good for you? Output is OpenXml XLSX file. Best
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 More
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 More
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
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 More