Change Excel Download column format to Text?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 2

I'm interested also if this is possible. I believe not because SSRS is rendering it as Excel.

jbalbo SSCertifiable Points: 7583 More actions · Answer 3

Hi Joe,

I found the downloaded excel file was in "General" format.

I needed to submit this file for processing thru an SFTP site, and wouldn't accept it as "General" and needed to be in "TEXT"

I ended up using a VBA script that I run just prior to submitting it, the .Parent.NumberFormat = "@" changes it to TEXT

Set xlObj = CreateObject("Excel.Application")

'Set xlFile = xlObj.Workbooks.Open("c:\temp\filename.xlsx")

'turn off screen alerts

xlObj.Application.DisplayAlerts = False

'loop through sheets

For Each Worksheet In xlFile.Worksheets

'change all sheets to desired font

With Worksheet.Cells.Font

.Name = "Verdana"

.Size = 12

.Parent.NumberFormat = "@"

End With

xlFile.Close True

xlObj.Quit