CODEWITHSUNDEEP
excel
Phillip Senn
Phillip Senn

Reputation: 47643

Removing formatting from a spreadsheet

I am using ColdFusion to read a spreadsheet, but it has a problem if the cell is formatted as a fraction.

Q: Is there a way to automatically remove formatting to a spreadsheet once the user has uploaded it?

Upvotes: 0

Views: 30

Answers (1)

Gary's Student
Gary's Student

Reputation: 96791

Before you process a worksheet, run this VBA macro on it:

Sub qwerty()
    Cells.ClearFormats
End Sub

Upvotes: 2

Related Questions