Danpol Posted November 17, 2018 Share Posted November 17, 2018 Hello, i have maybe very stupid question, but i'm looking for answer for days and found nothing, so i decided to make account here. How to move from column to column in function _Excel_RangeWrite()? I mean, i can move for example from "A14" to "A15" by "A"&14+1, but how make C from B? I have to write something in loop from column A to AG and making it without loop is terrible. Thanks for any advice! Link to comment Share on other sites More sharing options...
water Posted November 17, 2018 Share Posted November 17, 2018 It depends on where you store your data you want to write. Let's assume you have a two-dimensional array. This can be written with one call to the workbook. So if you can give more information what you try to achieve I can give further advice My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nine Posted November 17, 2018 Share Posted November 17, 2018 I think he wants to know how to move from col a to col b to col c etc up to col ag. One easy solution, you could have the list of the columns in a array, like Dim $Array[xx] = ["A","B","C",....,"AA","AB"..."AG"] “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy Link to comment Share on other sites More sharing options...
Danpol Posted November 17, 2018 Author Share Posted November 17, 2018 Yes, it can be write by array, it works fine, but now im on stage when user can choose where to start. Lets say i have 10 numbers to write, from B2 to K2. I can make a array[1][10] and paste it on B2, but i need something to allow me start on B+number, which enters, and save the data, which can be before that column B+number. Link to comment Share on other sites More sharing options...
Danpol Posted November 17, 2018 Author Share Posted November 17, 2018 1 minute ago, Danpol said: Yes, it can be write by array, it works fine, but now im on stage when user can choose where to start. Lets say i have 10 numbers to write, from B2 to K2. I can make a array[1][10] and paste it on B2, but i need something to allow me start on B+number, which enters, and save the data, which can be before that column B+number. which user enters Link to comment Share on other sites More sharing options...
Danpol Posted November 17, 2018 Author Share Posted November 17, 2018 List of the columns in a array sounds good, i hoped there is some easier method, which allow me to do somethink like "A"+1->column B Thanks anyway, i'll try with array Link to comment Share on other sites More sharing options...
water Posted November 17, 2018 Share Posted November 17, 2018 Use function _Excel_ColumnToLetter to translate numbers to column letters. ; Writes value $vValue to cells B1 to K1 $iStartColumn = 2 ; Column B $iColumnCount = 10 : Number of columns to process For $i = $iStartColumn To $iStartColumn + $iColumnCount - 1 $sRange = _ExcelColumnToLetter($iColumnCount) & "1" _Excel_RangeWrite($oWorkbook, Default, $vValue, $sRange) Next My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Danpol Posted November 17, 2018 Author Share Posted November 17, 2018 That's exacly what i was looking for! Thank you so much Link to comment Share on other sites More sharing options...
water Posted November 17, 2018 Share Posted November 17, 2018 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now