Solved

how to convert .csv file to xlsx file with tabs

Posted on 2011-09-20
8
515 Views
Last Modified: 2012-08-13
I want to convert csv to .xslx and put the data in tabs based on certain criteria, is there a way to do it thru excel macros or vb program.
0
Comment
Question by:panthi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36567164
You simply open the CSV file and then save it as .xsls.
0
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36567170
So open the CSV file using excel, and then save the file as xsls extension which will allow you to use all the excel functions, macros etc.
0
 

Author Comment

by:panthi
ID: 36567768
May be i am not clear. i understand that i  can do saveas, i basically want to automate this, that is the real question.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36570335
What is the criteria for dividing to tabs? You would have to use Office Automation.

http://support.microsoft.com/kb/302094
0
 

Author Comment

by:panthi
ID: 36573537
the criteria is value in one of the column
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36575932
Did you try the automation example?
0
 

Author Comment

by:panthi
ID: 36582628
To make it more clear this is what my task is
there is a csv file that is created by a program every day
I need to read that csv file based on the date and create a xlsx file as an output with seperate
tabs for each state. What is the most efficient way to do this i dont think automation example is right for the scenario mentioned.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 36593828
Given that you need to create additional sheets in xlasx file based on your criteria, I think automation is your only choice.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question