+ Reply to Thread
Results 1 to 18 of 18

I am trying to convert portions of this google sheets workbook into Excel.

  1. #1
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    I am trying to convert portions of this google sheets workbook into Excel.

    Could anyone be so kind as to tell me how =getCurrentStakesText(D1) in cells J1:K1 works.
    https://docs.google.com/spreadsheets...py?usp=sharing
    Please advice if your not able to open file from google sheets.
    Last edited by west123; 05-16-2023 at 10:46 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    getCurrentStakesText is a function written in Apps Script, Google's macro language. You cannot automatically convert this to Excel. The code would have to be rewritten in VBA.

    Here is the Apps Script code:
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    6StringJazzer, Thank you very much for the answer.
    Would need to get create another post to get the help, to be rewritten into VBA. cheers

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    Apps Script looks just like Java to me. This should do it but I haven't tested it yet.

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    You cannot automatically convert this to Excel. The code would have to be rewritten in VBA.
    Is this still true? As MSFT tries to move away from VBA, I thought they had made it possible to write UDFs in other programming languages -- including Java and Javascript. If this is true, one of the big advantages I see is the possibility of writing a UDF in javascript like the OP has done and using it across different spreadsheet platforms, but I have not seen anyone anywhere try to explain how that would work.

    Here's MSFT's introduction to UDFs using and Officescript add-in: https://learn.microsoft.com/en-us/of...tions-overview
    Is there enough information in there to explain how to make an appscript/javascript udf available to Excel?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    I don't have experience with using other languages for Excel macros but this looks promising. It does seem to require building an add-in.

    This approach would obviate the need to rewrite the code but I don't know how you build in the API calls (like getRange), and it would still not be a one-click conversion process. I am wondering if it would be more straightforward for online Excel using Office Script, which I don't have access to.

  7. #7
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    6StringJazzer Thank you
    I will post here see if someone is able to help with this. I know is a bit complicated. I apreciate the advice.
    cheers

  8. #8
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    I am trying to convert portions of this google sheets workbook into Excel. https://docs.google.com/spreadsheets...py?usp=sharing
    Would like to get help move Cash table from tournament to cash games, and the stats in.
    I would like the code to fill Cell O1 on the Cash Games sheet, and the data code will need is in colummns AF:AO on the Info sheet.
    please feel free to ask any questions.
    cheers
    Last edited by west123; 05-17-2023 at 12:35 PM.

  9. #9
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    thank you for the reply Mrshorty,
    but I have not much of an understanding, for all the above tech talk as for MSFT not sure what that means Barely know what VBA is.
    I create a post of what I actually need done, hope is not to complicated. apreciate the advice. Hope someone knows well and can contribu the help.

  10. #10
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    Hi,
    Would anyone be able to help in applying 6StringJazzers code in post #4 to my .xlsb file found in post #8?

  11. #11
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    I looked at your file but did not see where that function was referenced in the worksheet. Was the formula converted to values?

  12. #12
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    Sorry, I am not sure that I understand what you are asking. I would like cells O1:P1 on the on the cash games sheet to be filled using the code that you wrote. At the moment O1:P1 display a value just to show that the result should come from the Stakes Text column in column AH of the Info sheet. Please let me know if I need to add something else to the file

  13. #13
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    I am working my way through testing the code. Your code refers to sheets "Bankroll Rules" and "Worksheet" but these do not exist in the Excel file you attached.

  14. #14
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    I will try to include the spreadsheets into the workbook as soon as possible.

  15. #15
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    I could just try starting with your Google Sheets version instead but you have a lot of macro functions in there. If they are all needed, I don't have time to rewrite them all.

  16. #16
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    thank you, 6StringJazzer for what you, done. I will get back to you as soon I can, with and update.

  17. #17
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    @ 6StringJazzer: I have been helping West123 with the workbook. I have included the Bankroll Rules and Worksheet sheets in the file. Hope that this helps.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  18. #18
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,820

    Re: I am trying to convert portions of this google sheets workbook into Excel.

    Hi, 6StringJazzer,
    I would just like to rewrite the macro to populate cell O1 on the Cash Games sheet, not the whole workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. i cannot convert a Google sheets array formula to excel365
    By EzLedgers in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 09-20-2022, 04:59 AM
  2. Can you convert a VBA macro to google sheets?
    By SadCrow in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-09-2022, 09:18 AM
  3. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  4. How to convert excel aggregation/consolidation to google sheets
    By ISH1959 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-18-2021, 08:40 AM
  5. Replies: 1
    Last Post: 02-18-2021, 08:40 AM
  6. Convert Google sheets formulae to excel
    By TH1963 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-28-2020, 03:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1