- Ashok Pattanaik
- PowerBuilder
- Monday, 3 February 2020 04:23 PM UTC
Hello Team,
I am using PowerBuilder 2017 R3 version. As per the business requirement in my project, data will load from excel and display it in screen. But I am finding problem to read data from each sheet around 5-sheets in the same excel file.
Can you please help me how to read data from each sheet in the same excel file?
excel.workbooks.open(ls_currDirPath)
excel.application.visible = false
excel.windowstate = 2
excel.Range("A1:A49").Select
excel.ActiveCell.CurrentRegion.Select()
excel.Range("B1:B49").Select
excel.ActiveCell.CurrentRegion.Select()
ClipBoard('')
excel.Selection.Copy()
Thanks and Regards,
Ashok Kumar Pattanaik
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.