Anonymous
674 Views, 3 Replies
08-17-2016
01:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
08-17-2016
01:33 AM
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é
08-17-2016
01:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
08-17-2016
01:51 AM
- Aut viam inveniam aut faciam -
(I shall either find a way or make one.)
(I shall either find a way or make one.)
08-17-2016
01:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
08-17-2016
01:56 AM
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"
please feel free to "kudos"
02-07-2019
04:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
02-07-2019
04:41 PM
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.