ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

12 Q & A posts tagged with CSV

Mon
Dec 5
2011

Why won't Yahoo won't export contacts to .csv file?

I'm trying to create a csv file with all of my yahoo contacts. I hit the "export all" the file for a yahoo.csv, screen shows a file downloads but no contact data is included in the excel file. Its just an empty excel file that includes headers...ie first name, last name, address, email etc...but none of the contacts' data is included?
What am I doing wrong?


Answer

Could be a prblem in that file format
Try open it in Notepad

Also, try add some more contacts then export again

Did you try another format?

Monday 12/5/2011 3:06:03 PM
Sat
Nov 19
2011

How do I make a input Text field in Excel 2010 and how do I extract the value of it into other formula?

I'm trying to place a text field in my excel document that would be visible and editable when saving as .PDF or .CSV

So that when users enter a Value, my tables would adjust according to what they filled in.
When I go to the Developers tab, I can't seem to select the Text field option :/

Any ideas on how to do this?


Answer

Developers toolbar, doen't have textbox control, because you have millions of them already in the sheet
each cell can be a textbox control
You can modify the layout/format of that sheet to make certain cell looks like a textbox

Or, you can use Control Toolbox textbox
http://folder8.com/View/?7U5WAWLP8K72

Let me know if that helped or not

Saturday 11/19/2011 12:40:05 AM
Fri
Nov 18
2011

How to save excel file to text file without spaces?

I have tried everything. I have coordinates in an excel file like this: x1y3 all together with no spaces and in one column. Every time I save it as a text file it comes out "x 1 y 3" I cannot have spaces or " in the file. How do I fix this other than manually? I have 800 coordinates and I'm not about to fix this by hand.


Answer

Save it as CSV file
CSV file = Comma Separated Values

Which will put , as separator

Then you just need to drag that csv file into a notepad window and save it as txt

good luck

Friday 11/18/2011 4:57:48 PM
Mon
Apr 26
2010

I want the output of my PHP to be opened in EXCEL or OpenOfficeSpreadsheet. How can I do it?

I have one PHP program which use mysql database. I want t the output to be opened in EXCEL/OpenOfficeSpreadsheet(in a separate window) when I click on a link provided. Any option to do it other than to save it as a CSV?The problem with CSV is that it opens as a single column and I have to use text to columns option to convert into columns. Thanks in advance.


Answer

CSV is Comma Separated Values

Means if you use values with comma as separator, Excel will open in in multiple columns

like this
"Value 1" , "Value2 " , "The long value of 3rd column"

VBAXLMan http://www.dougboude.com/blog/1/2009/06/PHP-Export-to-Excel-Snippet.cfm

Monday 4/26/2010 11:56:54 PM
Sun
Apr 18
2010

Does anyone knows the command to put the data from excel into the R programme?

Does anyone knows the command to put the data from Excel into the R programme ( R programme is a statistical programme) I will be really thankful .


Answer

You need to export the data you have into CSV file format
Most statistical and database applications can read CSV formats

Good luck

VBAXLMan

Sunday 4/18/2010 10:24:46 PM
Sun
Apr 11
2010

How do you export numerical values from java into an excel file?

Is it possible to export an array of numbers generated by a java program into a column of numbers in excel?


Answer

You can easily export these array into CSV file
http://en.wikiversity.org/wiki/Java_File…
http://www.roseindia.net/java/beginners/…

CSV files are Regular Text files with extension of CSV

Excel by default would open CSV files when double click


VBAXLMan

Sunday 4/11/2010 3:16:34 PM
Mon
Apr 5
2010

Export/Save from Oracle to Excel Spreadsheet?

Im not getting the option to save to excel.

When I press save for tsv the program stops responding then I oracle shuts down. I have checked the pop up blocker is off, enabled downloadds from IE and have also made sure the path is correct from IE - windows, Still cannot get the option to save as .xls

Many Thanks


Answer

If you can try to do export to CSV format, Excel will also be able to read that

Try it

VBAXLMan

Monday 4/5/2010 6:31:43 AM
Fri
Apr 2
2010

Database records exported to Excel CSV encode language characters?

I have database records that use different language characters (European languages mostly). When exported to Excel file, CSV to be exact, these characters are come through as encoded. I have an example here, characters "zlw" output as "zlw". I tried "charset=UTF-8", "charset=ISO-8859-1" and nothing. Any ideas?


Answer

You might need several attempts
- Copy the CSV file, in case you messed it up
- Open the CSV file in NotePad (Open NotePad, drag the file to it.)
- Do "Save As", now what is the suggested format of the file?
- I recommend importing the file in Excel instead of open it
- In both cases, use the same format used in Notepad

I faced issues like that when I work with Arabic/Hebrew chars, and these steps usually work it out

If not, then pay attention to the format when you export the data from the database, most database applications give you the ability to choose the format when export

Good luck and don't forget, VBAXLMan is here

Friday 4/2/2010 3:25:51 PM
Tue
Apr 21
2009

How do I import data into a program like excel through a virtual RS232 port?

I bought a scale and a USB interface kit, which connects the scale to the computer by using a generic interface based on the RS232 serial standard. According to the manual, data sent from the balance is in USB format, which is then directed to a virtual port. This port then appears as an RS232 port to the application program. It came with a cd with software to create the required virtual port, but I don't know how to get an application to connect to the port, or which application to use.


Answer

I am afraid this will depend on the application you have in that CD

What is the type of the files that that application can export to?

If it is a common one (I guess they must have a common one) then you can easily export ti to Excel

Common ones like
Tab delimited text (TXT)
Comma Separated Values (CSV)
etc


VBAXLMan

Tuesday 4/21/2009 3:56:31 PM
Sat
Jan 17
2009

How can I copy my favorites (bookmarks) from my Pc to nokia e71 ?

I made the favorits as a htm file & excel , but dives couldn't open it !!


Answer

Try do it as CSV or simple text files, most applications can read those types

otherwise you need to know what format your phone accepts

VBAXLMan

Saturday 1/17/2009 2:49:42 PM
Wed
Jan 24
2007

Need to create an Excel file containing test questions and answers.?

We are in the process of automating a test. I need to create an Excel file that contains the questions, possible answer(s), correct answer(s), and some other things. For each question, I need to know how to input the possible and correct answer(s). Do I put each answer in a different field or in the same field. I'm not sure what type of database will be used for the project, but I know I can create the CSV in Excel. Any help would be appreciated.


Answer

I like the idea
Now,
In a new sheet, put the fields like this
QID, Question body, Correct answer, Answer1, Answer2, etc, thing1, thing2, etc

This could be the easiest way
Means that cells A1 to H1 will have these heads
in the cells below A2 to H2 this can be
1, What is your name?, Name1, Name2, Name3, Name4, Free1, Free2, Free3
2, How old are you?, 15, 16, 17, 18, free1, free2, free3

and so on

Enjoy my profile, I am the VBAXLMan

Wednesday 1/24/2007 8:48:19 AM
Sun
Dec 17
2006

How to convert web files in excel?

or how to covert txt file from dos to excel


Answer

Excel can read *.csv files
So just make your list a comma seperated list, like
V1,V2,F4,450
and so on, then
open the file in Excel, and it is all here in a sible sheet

Enjoy my profile, I am the VBAXLMan

Sunday 12/17/2006 5:12:24 AM

Tags

History