Skip to main content

How to open Excel file and get a Cell Value (OLE Automation)

  • June 27, 2023
  • 2 replies
  • 2 views

Dominique Sacre
Forum|alt.badge.img+2

Hi everyone,

Haven't seen an example from NetExpress product that can;

1. open an Excel file (say; myfigure.XLSX)
2. go to a certain cell (say; A3)
3. Then get the cell value and save it in a .DAT cobl datafile

Anyone here?  Thank you very much.

infoRene


#SupportTips/KnowledgeDocs

2 replies

Dominique Sacre
Forum|alt.badge.img+2

Hi everyone,

Haven't seen an example from NetExpress product that can;

1. open an Excel file (say; myfigure.XLSX)
2. go to a certain cell (say; A3)
3. Then get the cell value and save it in a .DAT cobl datafile

Anyone here?  Thank you very much.

infoRene


#SupportTips/KnowledgeDocs

Oh I forgot... I am still using NetExpress v3.1.11 (Merant) with an example folder under C:\\Merant\\Base\\DEMO\\OLEDEMOS\\EXCEL


Dominique Sacre
Forum|alt.badge.img+2

Hi everyone,

Haven't seen an example from NetExpress product that can;

1. open an Excel file (say; myfigure.XLSX)
2. go to a certain cell (say; A3)
3. Then get the cell value and save it in a .DAT cobl datafile

Anyone here?  Thank you very much.

infoRene


#SupportTips/KnowledgeDocs

Thank you Chris for the sample code.... you are always a great help

Thank you again :-)