InfoPath

Re: How to deal with IP linked image (Excel REST WS) limit 255 chars URL

NathanWynn — Tue, 14 May 2019 15:01:09 GMT

It's not possible as we are not setting values back to Excel WB in SP. There is no data connection and we use Excel REST service to just use the Chart model and the model graphs on the value we pass in the URL. So it could gets lengthy, but the linked Image only read upto 255 chars.

The simplified sample is representative of actual. I have seen reference of multiple range name in 1 ranges(). Example: Ranges('A1'|'A3') etc, but I don't know how to assign the values. Ranges('A1') = 1000 is easy, but Ranges('A1'|'A3') = ? how to assign 1000 to A1 and 2000 to A3 is the issue. No luck on my end in term of that.

Re: How to deal with IP linked image (Excel REST WS) limit 255 chars URL

Hilary Stoupa — Mon, 13 May 2019 22:31:46 GMT

Sorry - I don't really know of a way to do this. Is the sample you are showing representative of your actual data? Could it be the user could just pass in a start year, and you could use formulas in Excel to populate additional fields with that year incremented?

Re: How to deal with IP linked image (Excel REST WS) limit 255 chars URL

NathanWynn — Mon, 13 May 2019 20:10:26 GMT

PLEASE!!??

How to deal with IP linked image (Excel REST WS) limit 255 chars URL

NathanWynn — Sun, 12 May 2019 01:02:46 GMT

Hi,

I was very excited on the prospect of displaying Charts on an InfoPath after seeing this video

https://channel9.msdn.com/Blogs/donovanf/InfoPath-2010-and-Creating-a-Form-that-Consumes-a-REST-enabled-WCF-Service

I jumped up & down when I got my first chart on the form. That party came crashing when I realized the URL length limits at 255 chars.

I use an Excel chart model and passing values from another data source to graph.

I looked all over to find out the way to bypass, but doesn't look like I could. So now I have to ration the naming and ranges.

I created SD folder in lieu of Shared%20Documents

EC.xlsx for ExcelCharts.xlsx

CB for ChartBudget etc

My QUESTION: is there way to cut down the repeating of 'ranges'?

For example:

https://server/_vti_bin/excelrest.aspx/SD/EC.xlsx//model/Charts('CB')?Ranges('A1')=2018&Ranges('A3')=2019....

I would like to combine to something similar to this: Ranges('A1|A3|A5')=2018,2019,2020

Is it POSSIBLE? Please show me a miracle :)