Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing a CSV file, would like to skip first row in Excel
I am trying to import a CSV file that is generated as a log on a
machine that we have. I have created my own custom headings for the columns in the first row of the Excel Doc. I am able to import starting on the second row of the CSV file to remove the existing headings, but the data still overwrites my headings since it wants to start the import on the first row of the Excel file. I cannot edit the existing headings that the machine outputs in the logs. I would like to find a solution that is as user-friendly as possible. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing a CSV file, would like to skip first row in Excel
abright,
Import the whole file (including the header row), then use code like this to put in your desired headings: Range("A1").Value = "Heading for column A" Range("B1").Value = "Heading for column B" etc... HTH, Bernie MS Excel MVP "abright52" wrote in message oups.com... I am trying to import a CSV file that is generated as a log on a machine that we have. I have created my own custom headings for the columns in the first row of the Excel Doc. I am able to import starting on the second row of the CSV file to remove the existing headings, but the data still overwrites my headings since it wants to start the import on the first row of the Excel file. I cannot edit the existing headings that the machine outputs in the logs. I would like to find a solution that is as user-friendly as possible. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Text File into Excel | Excel Discussion (Misc queries) | |||
importing text file in excel | Excel Discussion (Misc queries) | |||
Importing File Structures to Excel | Excel Discussion (Misc queries) | |||
Importing .pdf file into Excel | Excel Discussion (Misc queries) | |||
importing another file format into Excel | Excel Discussion (Misc queries) |