Search the Community
Showing results for tags 'cells'.
#include <Array.au3> #include <Excel.au3> #include <MsgBoxConstants.au3> ; Create application object and open an example workbook Local $oExcel = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\trans.xlsx") If @error Then MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeR
I'm stuck on how to use for range selection .Cells function. Instead of _Excel_RangeSort($oWorkbook, Default, Default, "AD:AD", Default, Default, $xlYes, False, Default, "AE:AE", Default, "L:L", Default)and $aResult = _Excel_RangeRead($oWorkbook, 1, "S2:AB" & $iRows)which works properly I want to use Cells to select the range. Why? Because the Excel sheet was modified and an additional row was inserted. I want to create the script more dynamically by selection it with Cells because I can search for the column headers. Any idea? Thanks.
Okay, who is ready to point me to the quickest answer ever on this forum? I am attempting to make a listview type control and cant get my head around how to pull this off. Requirements DYNAMIC number of rows and columns Autoscroll capabilities for a set ctrl size Ability to click individual cells Issues with listviews I can select an item but that really just selects the whole row - perhaps I am missing a style or exstyle setting? meets all other requirements Issues with table.au3 even modified to use input boxes Don't know how I would stick entire table into some type of ctrl bo