aqa | AQA Installation and development notes | File Utils library

Thanks to the posts suggested by @Tanaike, the solution I've come up with is as follows. It is very dirty and not well written but it works.

Workflow...

1. Get spreadsheet ID and folder ID;
2. Open a copy of the spreadsheet;
3. Export as XLSX;
4. Change filetype to zip;
5. Unzip into a blob;
6. Create object to hold xlsx worksheet ids/sheet names, image locations and filenames and Drive image ids for newly created images;
7. Iterate through each blob in the blob;
8. Find the xl/workbook.xml file and retrieve sheet id and names;
9. Find each xl/drawings/drawing#.xml files and retrieve sheet, location and image filename;
10. Find all images, save to drive and retrieve and map drive ids to filenames;
11. Go through each sheet in the Google sheet;
12. Iterate through each cell;
13. When you find a cell starting with 'com' which ISN'T a formula, generate the image id from the sheet id, row and column, find the corresponding image name and then the corresponding google drive image id.
14. Clear the cell contents and reinsert as an =IMAGE() formula;
15. Add a note to the cell with the image name.

With help from the comments here are the answers I found to work.

This will fetch the columns when the string entered, exactly matches what you are looking for.

You have a typo in

+ "and dct.code in ('EMAIL', 'EMAIL2)\n"

it should be

+ "and dct.code in ('EMAIL', 'EMAIL2')\n"

It is possible that there are other problems, but you need to post a complete error message, in your question it is truncated and almost useless. For example, you can try to execute this query (with fixed typo) by using the JDBC directly.

In the edited question you have another error. from microfusa from microfusa p should be from microfusa p.

If you want to sort first by increasing values of getCompanyName() and then by decreasing values of height(), your predicate needs to be:

You can use a map from stream to perform this task, it should look like something like this in case your Map has exactly one value