Excel Column Cutter
Project ID:
788544Project Type:
FixedBudget:
$30-$250 USD
Project Description:
I need the service provider to create an user intesface, with parameters, in PHP. The objective is to copy columns out of an MS Excel file by "column_count" and paste the data in a csv file. The parameters would be: select input file, choose colums (1,3,4 [or] 1..15); and paste the data and column headers in an output csv file. The Excel file will constantly have a different amount of columns and rows. The application must do a check to see that all the data is present in the csv file.It is important that the "select column field" allows for a range of columns to be stipulated, and that the column headers and data is pasted correctly in the output csv file.
Skills required:
PHP, Software Architecture
Public Clarification Board
5 messages
-
alphamaster
Should the PHP web interface upload an xls file too?
Do you just need a php function which accepts the xls file name csv file name and the column_count string and cuts the proper columns and paste it in the file with csv file name: cutxls2csv($xls_filename, $csv_filename, $column_count).
If you also want a web interface what it should exactly be. From where the excel file will come. Should the page upload the file to server, cut and convert it to a CVS and then download the result csv file from server address?
If so please let me.
I have already prepared the cutxls2csv function completely working.over 1 year ago
-
blinkwater01
The user should be able to choose any column number and seperate multiple columns with a comma. The 1,3,4 is merely example of coumn counts. The user must also be able to stipulate any range of columns, 1..15 is only an example I used!
over 1 year ago
Awarded Bids
All Bids ()
LeaderTeam
|
LeaderTeam
From Ukraine
Offline
|
US English Level 1 (85%, 30th percentile)
HTML Level 1 (98%, 100th percentile)
JavaScript Level 1 (75%, 50th percentile)
PHP Level 1 (83%, 95th percentile)
SQL Level 1 (90%, 85th percentile)
WordPress (80%, 89th percentile)
General Freelancer Orientation (80%, 90th percentile)
alphamaster
|
|
alphamaster
From United Kingdom
Offline
|
Freelancer Orientation (80%, 97th percentile)
himanshuhc
|
|
himanshuhc
From India
Offline
|
General Freelancer Orientation (95%, 100th percentile)