Đã Hủy

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

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.

Kĩ năng: Kiến trúc phần mềm

Xem nhiều hơn: macro convert csv excel, convert csv excel graph, write program convert avi flv, how to force excel to open csv files with data arranged in columns, convert csv to excel python, how to open csv file in excel 2016, convert excel to csv comma delimited, how to open csv file in excel with columns, convert csv to excel command line, how to convert csv to excel with columns, convert csv to excel, convert csv excel chart, convert csv excel, vba convert csv excel, visual basic net convert csv excel, write program convert ipv4 ipv6, bird and cronin - convert online catalog to csv & excel, bird and cronin convert online catalog to csv excel, i need a website that will write an essay for me, how are you i am writing this letter to inform you that we should no longer see it other because i need to concentrate on my stu

Về Bên Thuê:
( 16 nhận xét ) Hong Kong, Hong Kong

ID dự án: #18785701

11 freelancer đang chào giá trung bình $276 cho công việc này

ineedWorkJob

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i will develop the command line program to convert from csv to excel and vice versa along with hide, protection and form Thêm

$500 HKD trong 1 ngày
(142 Nhận xét)
6.8
mrbrave

Hi, I will create a .Net based command line tool, which will work on windows platform. It will take input and output file as parameter and auto judge the conversion method based on file extensions. If you ok wi Thêm

$390 HKD trong 2 ngày
(26 Nhận xét)
4.6
$260 HKD trong 1 ngày
(7 Nhận xét)
4.0
mrherkar

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

$220 HKD trong 3 ngày
(4 Nhận xét)
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 Thêm

$80 HKD trong 1 ngày
(0 Nhận xét)
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 Thêm

$251 HKD trong 7 ngày
(2 Nhận xét)
0.0
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 Thêm

$200 HKD trong 1 ngày
(0 Nhận xét)
0.0
fivestarOne

Hello, sir i have been updated Spork Execl as Python. SKILLS FOR YOUR PROJECT: Python, PHP, DHX,React JS. i can do it perfectly I have 7+ years of rich experience in Website Development. I will provide : 1. Thêm

$200 HKD trong 1 ngày
(0 Nhận xét)
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 Thêm

$500 HKD trong 3 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 Thêm

$200 HKD trong 1 ngày
(0 Nhận xét)
0.0