I've got an excel file being saved to do, everything works fine, but one of my cells I need to preserve underline, bold, and italics. I found this http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_25022797.html but this is a script for using in Excel. I need something just like it but running on the excel File when they upload it.
Right now I have this code:
Protected Function ExcelConnection() As OleDbCommand
' Connect to the Excel Spreadsheet
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("~/temp/ExcelImport.xls") & ";" & _
"Extended Properties=Excel 8.0;"
' create your excel connection object using the connection string
Dim objXConn As New OleDbConnection(xConnStr)
' use a SQL Select command to retrieve the data from the Excel Spreadsheet
' the "table name" is the name of the worksheet within the spreadsheet
Dim objCommand As New OleDbCommand("SELECT * FROM [Accomplishments$]", objXConn)
View Complete Post