Graphics

 View Only
  • 1.  HOW TO CONNECT MULTIPLE EXCEL SHEETS INTO 1 GRAPHICS?

    Posted 4 days ago
    Hi Guyz
    I have 1 excel file connected to XPN via datalinq. The single excel file contains multiple sheets. Each sheet is identically structured but with different data.
    I want to give the option to the end user firing the graphics to choose any of the excel sheet from the excel file. Is this possible without scripting and if YES then how?

    User case scenario: FOR ELECTION
    Single Excel file has multiple sheets named after each state. Each sheet contains the election data of that state. The excel file is connected to 1 graphic via datalinq.
    The end user should have the option of choosing the state from the dropdown list in sequencer and that state data gets displayed in the graphics.

    Thanks
    Gaurav

    ------------------------------
    GAURAV SODHANI
    Freelancer
    ------------------------------


  • 2.  RE: HOW TO CONNECT MULTIPLE EXCEL SHEETS INTO 1 GRAPHICS?

    Posted 4 days ago
    Hi Gaurav!

    After connecting your graphic to your Excel file via datalinq, navigate to the Take Inspector window in the Sequencer. Under the Template Data tab, click on the object you want to change the sheet for. Datalinq Properties will pop up to the right and there should be a property called Table. For our graphics, that property has a value of "Sheet1$". As long as the column titles stay the same across all the Excel sheets, a user should be able to change that Table property and the data will update in your graphic.

    Hopefully this helps!

    ------------------------------
    Nick Kubinski
    ------------------------------



  • 3.  RE: HOW TO CONNECT MULTIPLE EXCEL SHEETS INTO 1 GRAPHICS?

    Posted 3 days ago
    Hi Nick, appreciate your response.
    What i want is to change the data for entire graphics which has more then 20 data elements connected to the excel sheet, by a single click change of the data sheet. 
    I was able to achieve this by adding a macro in the dataliq to the TABLE (@TextObject@) in all my 20 data elements in the XPN graphics and having a seperate text element with combobox to select the name of the excel sheet. So what is exposed in the sequencer is the drop down names of the my excel sheet which when selected changes the TABLE name in all my XPN data elements connected.

    Problem resolved.

    Thank you

    ------------------------------
    GAURAV SODHANI
    Freelancer
    ------------------------------



  • 4.  RE: HOW TO CONNECT MULTIPLE EXCEL SHEETS INTO 1 GRAPHICS?

    Posted 2 days ago
    Excellent! I'm glad you were able to work it out Gaurav.

    Have a great new year!

    ------------------------------
    Nick Kubinski
    ------------------------------