General information
Category:
COM/DCOM and OLE Automation
>>>HI
>>>
>>>I want to write formulae into a range of columns. Can I use a numeric refernce to excel columns or do I have to work out the cell reference like AA,AB etc
>>>
>>>Thanks
>>>
>>>
>>>Nick Mason
>>
>>
>>Its ok
>>
>>I can see I can use the R1C1 format to reference cells.
>>
>>well done
>>Nick
>>Thanks Nick
>
>
>Hi there :)
>
>If you have complex exports to excel (writing in predefined cells)
>You can have look at my rep2excel tool here in downloads.
>
I'll take a look at that thanks.
Nick
>Among the other things, you can write precisely to excel templates using 3d positioning system - nSheet,nRow,nCol
>
>so using calls like like ;
>
>oXl.make_cell(1,25,5,'EasyExport')
>oXl.table_in_section(1,27,5,'myAlias')
>
>you can relatively simple accomplish very complex exporting tasks.
>
>Rgds++
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only