Ilogic read excel cell with format

[Anonymous]

Hi,

is it possible to read excel cells with the format (different fontsizes, underlined words,...)

At the moment i am using this code:

SyntaxEditor Code Snippet

GoExcel.FindRow("\\SV-VAULT2\VaultDaten\Vorlagen allgemein\Beschriftung Zeichnungskopf.xlsx", "Tabelle1", "Parameter", "=", "SYMBOLTEXT1")
iProperties.Value("Custom", "SYMBOLTEXT1") = GoExcel.CurrentRowValue(Sprache)

But i can read the information only and not the excel format.

Thanks in advance!

André

[frederic.vandenplas]

Sorry, i've posted under my collegue his account

Hi,

This sample checks if the first cell is bold or not, you can modify change it according to your needs

This is done using COM, so you may check for errors, other open documents and so one before proceeding

ExcelApp = GetObject(,"Excel.Application")

'MsgBox(ExcelApp.activeworkbook.ActiveSheet.cells(1,1).Value)
If ExcelApp.activeworkbook.ActiveSheet.cells(1,1).Font.Bold = True Then
MsgBox("Cell 1,1 is Bold")
Else
MsgBox("Cell 1,1 is not Bold")
End If

[RoyWickrama_RWEI]

Currently I am doing a lot with reading from and writing to type of coding to support huge assemblies.

The code is giving me some idea: will explore over the weekend.