Skip to Content
author's profile photo Former Member
Former Member

Xcelsius2800 refeshing data without webservie (excel Data?)

Hallo,

Id did some development on Xcelsius months ago and just started to aktualise my knowlage with Xcelsus 2008

I remenber refreshing dada from external excel-files while selecting spezial Regions so did'nt have to import whole model

but have a datatable(range) beeing refreshed ...

I have not found this feature ...what is the reason... how to do... maybe a connection to excel with Life-Office-Data...?

Thanks for any hints

karl

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jan 18, 2011 at 09:44 AM

    Hi kgs-ks,

    you can automate the process of data consumption from Excel with the help of Live office connection

    For that : open the Xcelsius then go to File -> Preferences -> Excel Options -> enable the Live office Check box. and use the functionality offered by Live Office

    Or else u can use the functionality offered by the Excel only

    Save your Excel Source data as XML Spreadsheet into some common loaction.

    Now open your Xcelsius Dashboard -> go to Developer Tab (if not visible open Excel -> Click on the office button -> Under Popular -> check the show Developer tab in the ribbon) -> Click on the source -> Add XML maps -> select the previously saved XML source file -> Drag the <value> from XML source on spread sheet -> Click on Data Refresh -> manipulate data according to requirement -> map those cells to your Xcelsius components. -> Go to Data Manager -> Add Excel XML Maps -> go to usage tab -> refresh by (according to requirements).

    and u will have a automatic connection.

    Note: make sure you save the updated source file as XML spreadsheet in the same shared location.

    There is another option available

    Use Add-ons available

    Open Xcelsius -> File -> Manage Add ons -> -> click on Get More Add ons -> try some freely available Add-ons for CSV file connector -> Save your source file in CSV format and use the same. (You will get a new connection under Data Manager)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2011 at 01:44 PM

    You need to leverage XML Maps in Excel Or Live Office / QaaWS from BusinessObjects Enterprise OR Web Services

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2011 at 08:56 AM

    hallo,

    I just found out under "export" to include data "from other xls-sheet"

    have to test it

    kgs

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2011 at 06:05 PM

    thanks to Debjit_Singha for the usful informations

    i had found another point: you can set export options to "other excel file"

    i did not use this yet

    but seems to have an extern excel-workbook with same structure containig the actual data

    kgs

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.