Search the Community
Showing results for tags 'cell'.
-
Hello. I have IETable, Get by this code $oTable = _IETableGetCollection ($oIE, 1) $aTableData = _IETableWriteToArray ($oTable) Local Const $iArrayNumberOfCols = UBound($aTableData, $UBOUND_COLUMNS) Local Const $iArrayNumberOfRows = UBound($aTableData, $UBOUND_ROWS) Local $aArraySubstr...
-
Yesterday I had to make some little changes to an old Autoit program we use at my work. The program reads some data and convert it to Excel. Before writing the cell, it is changed to text and later on I slap the column with an autofitwidth. Furthermore weI execute a conditional format on the s...
- 12 replies
-
- excel
- formatting
-
(and 1 more)
Tagged with:
-
I am a newbie in AutoIt. May I know what is the code used to expand the width and height of excel cells because I want to insert pictures in the cell.I tried AutoFit but that doesnt work as I cant specify for the width and height. Only for column width I could expand by using .ColumnWidth but for th...
-
I am a newbie in AutoIt. May I know what is the code used to expand the width and height of excel cells because I want to insert pictures in the cell.I tried AutoFit but that doesnt work as I cant specify for the width and height. Only for column width I could expand by using .ColumnWidth but for th...
-
I saw in the Help File, the UDF for managing Excel 2013 and on Windows 7, but I can't manage how can I add silently a specific value in a specific cell in a specific Excel file Pls help me And yes I updated to the last version of Autoit...
-
Sorry if this is a silly/stupid question, but I was curious how to do this. I am trying to check dates in an excel column to get usage statistics, and the date is formatted like MM/DD/YY. I would like to pull this out as a string, and separate this into 3 variables for month, day, and year to be...
-
I've got a tab delimited text file that needs column headers added. As you might be able to see it's for an Amazon Order confirmation File. With my current experience with autoit I figured the best way to make this happen would be to use excel. Only problem is that excel is being a punk and c...