Go Back   Singapore Web Hosting Talk > TECHNICAL > Programming Forum

Programming Forum Web applications, languages and other related issues in configuration, optimization, practical usage and database connectivity.

Reply
 
Thread Tools
Old 06-02-2012, 12:48   #1
tangara
SGWHT Newbie
 
Join Date: 24-05-2010
Posts: 9
tangara is on a distinguished road
how to change csv to excel format?

Dear forum members,

I'd like to seek how to change csv file into excel format.

Basically, my webhoster has changed the MyPHP admin database to a newer version and only allows download in csv format.

Alas, the csv format is very messy, alot of ,, between all the fields and data.

I'd like to know the downloaded file in csv can it be converted to excel format easily?

Any advice is greatly appreciated.
tangara is offline   Reply With Quote

Old 16-03-2012, 23:26   #2
davidktw
SGWHT Newbie
 
Join Date: 16-03-2012
Posts: 3
davidktw is on a distinguished road
Quote:
Originally Posted by tangara View Post
Dear forum members,

I'd like to seek how to change csv file into excel format.

Basically, my webhoster has changed the MyPHP admin database to a newer version and only allows download in csv format.

Alas, the csv format is very messy, alot of ,, between all the fields and data.

I'd like to know the downloaded file in csv can it be converted to excel format easily?

Any advice is greatly appreciated.
Excel can import csv, isn't it ?
davidktw is offline   Reply With Quote
Old 20-03-2012, 11:07   #3
jahja
SGWHT Newbie
 
Join Date: 25-06-2007
Posts: 28
jahja is on a distinguished road
re: how to change csv to excel format?

To my knowledge, for excel export, most programmers (including myself) export to csv format in php. Because this is the most convenient way. If you want to export to excel format in php, try PEAR :: Package :: Spreadsheet_Excel_Writer.

If you want to do it on Windows (using C#.Net or VB.Net), employ Microsoft.Office.Interop.Excel to do the translation.

But the easiest way, of course, just go straight to Microsoft Excel and open the csv file. As long as the csv file, has the correct extension (.csv), Microsoft Excel is always do the job to read the file correctly.

Last edited by jahja; 20-03-2012 at 11:17.
jahja is offline   Reply With Quote
Old 04-11-2012, 16:01   #4
heather
SGWHT Newbie
 
Join Date: 30-03-2007
Posts: 1
heather is on a distinguished road
there is a possibility to export to excel without PEAR, but your questions lies in PHPmyadmin, how new is that version of PHPmyadmin? i've been using the latest one (nearly 6mths old update) and i'm still able to export it into EXCEL.

save it in CSV, open it in MSEXCEL and resave it in XLS if you're viewing with a notepad.
heather is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump




All times are GMT +8. The time now is 02:56.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Copyright (C) 2002-2012 Brought to you by Singapore Web Hosting Talk (SGWHT). All Rights Reserved.