Search the Community

#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_RangeRead Example", "Error opening workbook '" & @ScriptDir & "\trans.xlsx'." & @CRLF & "@error = " & @error & ", @extended = " & @extended) _Excel_Close($oExcel) Exit EndIf ; ***************************************************************************** ; Read data from a single cell on the active sheet of the specified workbook ; ***************************************************************************** Local $sResult = _Excel_RangeRead($oWorkbook, Default, "A1") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended) MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Data successfully read." & @CRLF & "Value of cell A1: " & $sResult) Hi, all. Ok, here is the deal. I have simple excel file called trans.xlsx. It's located in the directory of script. In general i don't care where to store it. What i do need is to open excel file and copy one by one numbers from cells. I've tried different ways, examples. But i only get error, says: error = 3, extended = 1. I saw different posts from different years. I even tried to use simple example from manual file. But always get error. In general my goal get numbers one by one and post it to let's say search filed in my PC one by one. Or to notepad (but one by one, in kind of loop). I've learned how to copy or show in message box some info from other apps. But with excel i'm stuck. I'm able to open needed window based on "title" of excel. But i don't succeed of copying info from cells. Would be appreciate for any help. So, in this code i'm trying at least to read from cell A1. Doesn't matter what Sheet. I use Windows 10, Excel for Office 365. Thank you in advance.

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 box that would do the autoscroll capabilities when the table starts to get large Groupbox? Issues with Embeded excel No way to know for sure that computer that is being used will have excel Don't want to go down the road of making sure installed if I don't have to. Another possible answer is Gridviews but there isnt much info on these in the forum other than how to interact with one already in another application. Not sure how I might go about creating one for myself in autoit So there we go, I have scoured the forums and I can post some code if that helps. Not sure how it will as the code I have works as expected from an Autoit standpoint, just not what I need. Let the 'Ah Ha' moments begin!