Ask Your Question
0

Query like SQL on office calc

asked 2020-12-04 09:06:23 +0200

kdev gravatar image

updated 2020-12-04 09:07:22 +0200

Hi :),

Is it possible to query tables of a spreadsheet using SQL?

I saw a similar question but for me it wasn't clear enough.

Thanks in advance

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-12-04 22:34:30 +0200

Ratslinger gravatar image

Hello,

There is no SQL in Calc. This is available when using a database. In LibreOffice this is through use of Base and can be accessed in Calc when the Base file is registered. The "similar" question you mentioned is probable not so similar. That question was dealing with extracting specifics from a csv file. Calc did not seem to be a requirement but rather how the csv file was originally opened.

It also seems you question is not exactly clear. Main question states Query like SQL and detail states using SQL. So there seems to be the possibility of something other than SQL would solve your question but there is nothing stated as to what you are trying to accomplish.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-12-04 09:06:23 +0200

Seen: 40 times

Last updated: Dec 04 '20