Hi, i am sharing an excel sheet in my drive and am trying to read in into my app. Unfortunately, it looks like it cant read the full mentionned range but only a very small part of it.
When i switch this excel sheet for a more common google sheet (another document), I have absolutely no problem at all reading the full mentionned range.
I have tried with another excel sheet and faced the same problem.
Question is: is it a known issue with excel sheets (because chrome/brave/vivaldi/Firefox dont handle all excel macros/functions) or is it something else i am missing?
Many thanks for the incoming help
no I did not cause the excel sheet is quite complicated: i have tried to export to a csv to then fetch and sort datas, but it would be a long and hard work.
I import the data this way
I noticed that depending on the range i set, the import goes more or less smoothly.
I think the easiest way will be to create a macro in my excel sheet that will process the data on my sheet to make it easier to use.
If ever it eventually works, my next step would be to add automatic query buttons like Tracteur that would send a query with a simple click on it. Dont know if its possible.
What do you mean there is no column called Tracteur: the first five are called Tracteur.
Should I query this way: select B, C, D, E, F ? How could i make this query easier?
yes, sorry, I had read it, but obviously read too fast the way you have to query.
Is it possible to go deeper and had a button that would automatically do a query like SELECT B,C,D,E, F where E contains ... so user would only have to write one word?
Another question: is it possible to query the headers? I mean, I have three different headers, and I'd like to make a query so that only the requested columns appear (like the columns with the Tractor header). I've created this csv so that I can query in this way.
Yes, I admit I would be happy to query by rows or by headers.
Thanks a lot for the time you re spending on my noob requests...
And by one word, it would either be Tracteur, or any other like LCM, DPS, etc..
There are several ways you could do this. I will suggest below what is probably the easiest to setup:
Create a new worksheet in your spreadsheet
Put a transpose formula on cell A1, in Google Sheets this would be something like: =TRANSPOSE(('originalsheet'!(1:1000) - the whole sheet
Query like this: https://docs.google.com/spreadsheets/d/193Kssa9UZ3WJT1X0TmlvEF9rnQIo40cTpa3gPgz8JX8/gviz/tq?tqx=out:csv&gid=1865627609&tq=SELECT *WHERE A contains 'Tracteur'
In the app, you would need to run a procedure to transpose the data back to the original layout:
Amazing! Many thanks for this juge job, i am now gonna try this solution and see what I can do with it. Thanks again for the great job and help you provided!
Unfortunately cant manage to have this working. I get every time i run query the same answer: Cannot parse text argument to "list from csv table" as a CSV-formatted table
Well, in your example, the single quotes are already in the blocks this way
so I reproduced it.
I thought it would mean i dont need to add any more quote to my query. So i was quyering Tracteur.
Anyway, I have tried both ways, with or without single quote and I am facing the same error message. gVizQueryD.aia (4.5 KB)
The only thing i can figure would be to call two different webviewers with two different queries. But I am pretty sure there is an easiest way to do so...