Reading data from google spreadsheet

Reading data from google spreadsheet

  • 27 Dezember 2019 um 7:47 am #35246
    Praveenraj
    Teilnehmer

    Hi,
    Im trying to get data from google spreadsheet via script, previously i got data from excel via script for that i added „microsoft.office,interop.excel“‚ in edit references. Like that any other references are there for Google spreadsheet? or something else i have to do, for reading data from google spreadsheet ?

    Regards,
    Praveenraj.k

  • 3 Januar 2020 um 11:02 am #35272
    ThomasIslera
    Teilnehmer

    Hi Praveenraj,
    I think you can configure a button that opens the web browser with the „open application“ command to access your google spreadsheet.
    Or you can directly integrate a web browser object inside the screen.
    Movicon NExT has in its tool box an object called Spread Sheet but is to interface local files.
    Regards
    Tom

  • 4 Januar 2020 um 6:30 am #35285
    Praveenraj
    Teilnehmer

    Hi Thomasislera,
    Actually I’m not reading a total spreadsheet, I just try to get values from some of the cells and map that particular cell value to a tag in our io server, then use those tags in Visualization and storing those values in the database and so on. Earlier I get data from excel via script. Now just trying to use google spreadsheet instead of excel.

    Sample Code:-
    „Motor_runhours= xlWorkSheet.Cells(11,8).value“
    –Motor_runhours is an tag we created in io server.

    Regards,
    Praveenraj.k

  • 4 Januar 2020 um 6:30 am #35286
    Praveenraj
    Teilnehmer

    Hi Thomasislera,
    Actually I’m not reading a total spreadsheet, I just try to get values from some of the cells and map that particular cell value to a tag in our io server, then use those tags in Visualization and storing those values in the database and so on. Earlier I get data from excel via script. Now just trying to use google spreadsheet instead of excel.

    Sample Code:-
    „Motor_runhours= xlWorkSheet.Cells(11,8).value“
    –Motor_runhours is an tag we created in io server.

    Regards,
    Praveenraj.k

Du musst angemeldet sein, um auf dieses Thema antworten zu können.