Skip to main content

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

  • June 27, 2023
  • 2 replies
  • 0 views

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

  • Author
  • Rocketeer
  • 19312 replies
  • June 27, 2023

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


  • Author
  • Rocketeer
  • 19312 replies
  • July 4, 2023

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 :-)