Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
674 Views, 3 Replies

Ilogic read excel cell with format

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é

jurgen.galba
in reply to: Anonymous

 

 

- Aut viam inveniam aut faciam -
(I shall either find a way or make one.)
frederic.vandenplas
in reply to: Anonymous

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
If you think this answer fullfilled your needs, improved your knowledge or leads to a solution,
please feel free to "kudos"

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.