Hi there
I need the ability to create QR codes in bulk. I have found a way to do this en Google sheets - I'm using this formula( =IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="&ENCODEURL(D2))
where "D2" is the URL.
I have tried using Power Query to get the data, but it returns everythin but the QR codes. It does not give me an error. It just returns blank cells.
I'm guessing that there is a limit to what Power Query can return, but is there a workaround to get it to import the QR codes aswell?
I'm working on a corporate PC, so installing add ons to Excel isn't possible.
All the best
MBWalther
I need the ability to create QR codes in bulk. I have found a way to do this en Google sheets - I'm using this formula( =IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="&ENCODEURL(D2))
where "D2" is the URL.
I have tried using Power Query to get the data, but it returns everythin but the QR codes. It does not give me an error. It just returns blank cells.
I'm guessing that there is a limit to what Power Query can return, but is there a workaround to get it to import the QR codes aswell?
I'm working on a corporate PC, so installing add ons to Excel isn't possible.
All the best
MBWalther
