scany VS excelize

When I don't use one, I'm typically using SQLx or (if using Postgres) pgx with scany https://github.com/georgysavva/scany (slightly better API than SQLx and great performance since you can use the native interface from pgx if desired whereas many database drivers only offer the text-based interface).

If you want something like sqlx and you already know you're using pgx, a better choice is probably https://github.com/georgysavva/scany since you can use the native interface and get the same key features.

github.com/georgysavva/scany (v1.1.0)

I like to use pgxscan from https://github.com/georgysavva/scany

There's also bqb. We use it in production at our company -- much better than raw SQL. If you couple it with something like scany then you get more of the ORM benefits without the complexity.

Then I found out that WPS only supports ecma376 standard encrytion for xlsx files. Then I referred to the official documentation and libraries in other languages, such as msoffcrypto-tool written in python. msoffcrypto-tool) and go's excelize. Since I don't know much about encryption and decryption, the process of implementation is also a bit of a twist.

But if you absolutely need xlsx files, I would seek the best library for the job and write this in golang.

Documentation website with multilingual: Arabic, German, Spanish, English, French, Russian, Chinese, Japanese, and Korean, which has been updated

Golang excel: https://github.com/qax-os/excelize

Yeah, I'm reading it now and just parse, I didn't find a implementation of "calculation engine" all the available libs just read previous saved value from a opened and calculated excel file. See: https://github.com/qax-os/excelize/issues/65

Hey guys, i tryed using this https://github.com/qax-os/excelize to read excel table ,(70+columns and 500k rows). When using the sheet method from the documentation it takes about 3 to 4 minuts to find search item, and ofcourse limitation is that it needs to be a match.

Much like excelize for go lang.

Suggestion: When a method is safe for concurrent use, document such in its godoc comment. None of the formal documentation mentions concurrency, and its unclear what methods are concurrency-safe. The only tip-off that something might be safe for concurrent use is the occasional use of the sync package. This eventually led me to a year-old release footnote as the only documentation across the entire project about concurrency. This information isn't even in the Git tag, just the GitHub release page.

The title more or less says it all, but to give some background to the question, as long as it’s done safely (for example, with a mutex and locks) like with concurrent writing to a txt file, does anyone know if concurrent writing to an excel file, particularly while using excelize/v2 is possible? I have a 2D slice of data produced after processing an image that needs to be written to an excel file created with excelize/v2 and it’s plenty fast up to a certain set of dimensions, but I’d like to support even larger dimensions and was considering using concurrency to do so. But the only examples of concurrently writing to a file with Go that I could find were txt file examples. So I’m not quite sure if my scenario is possible.

You’re unlikely to find a single package that will handle all these file types without being behind a paywall of some sort. And I haven’t extensively worked with any of the other file types you’ve mentioned, but for xlsx, I highly recommend this package