Hi everyone,
I want to copy fonts from some of the existing cells (from the „Setup“ sheet) so when I’m exporting cells from my program to excel , user can modify the „template“ and change fonts for some special cells/rows in the xlsx…
I’m using Capesoft Office Inside template and can do that with copy/paste functions (which also copy font, syyle and everything else) but when are a lot of data export is very slow because of that, and there is always a problem with multitasking (per example user is writing emails while waiting for the export to end and also uses copy/paste so his copied text finishes in the xlsx file… )…
I guess I should use the oiGetProperty function but an example of how to use it would be nice.
Have you played with putting your data in XML via a Queue and reading it in office via VBA.
Its a lot faster than using OLE unless cape soft uses a com interface.
Com interfaces in C# can also be slow for accessing cells in excel…
Direct VBA is the fastest by a long way…
The only way to directly access office via DOT net is to use function delegates passed to clarion by Address to Typed functions in Clarion 11,