ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel CSV Error (https://www.excelbanter.com/excel-discussion-misc-queries/46690-excel-csv-error.html)

GKR

Excel CSV Error
 
From our intranet we routinely expose a link to export underlying datasets
to excel via
Response.ContentType = "application/csv"
Response.AddHeader("content-disposition", "filename=fred.csv")

This has been successful until recently.
One machine now opens the file into 1 column in excel.
Base set up: XP, Office 2000
Troubled machine does have SP2. Others SP1.
The regional settings appear consistent to working machines.
Regional settings English (United States)
List separator = ","
When he exports a csv file from excel it is comma separated.
Any Ideas? Have others resolved this issue?
Thanks.




All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com