How to insert more than 26 columns names into Excel sheet

HCL Domino Domino Forum
1

I am exporting current document into excel.This document contains more fields I have given like this for columns from A to Z and I had more fields to export can any give an ides to include more column names z.worksheets(1).Range(“W3”).value=“Category”

z.worksheets(1).Range("X3").value="Subcategory1"

z.worksheets(1).Range("Y3").value="Subcategory2"

z.worksheets(1).Range("Z3").value="Short Description"

with hope

thanks alot

2

Subject: how to insert more than 26 columns names into Excel sheet

Just look at what happens in Excel when you go past column Z, the columns become AA, AB, AC, AD… BA, BB, BC and so on.

3

Subject: how to insert more than 26 columns names into Excel sheet

If you open excel you will see that after column Z comes AA AB AC AD etc.

4

Subject: RE: how to insert more than 26 columns names into Excel sheet

thank you for ur responsesnow its working fine