One click export from spreadsheets to GnuCash

Larry Evans cppljevans at suddenlink.net
Sat Mar 12 08:41:54 EST 2016


On 03/11/2016 06:29 PM, Tommy Trussell wrote:
> On Tue, Mar 8, 2016 at 10:46 AM, One Click To Qif <oneclicktoqif at gmail.com>
> wrote:
> 
>> I created OneClickToQIF: a freeware and open source
>> project: with OneClickToQIF is very quick and easy to move data from
>> spreadsheets to GnuCash or other bookkeeping application, using the
>> former for insertion and some calculations, and the latter for all the
>> functionality of a double-entry bookkeeping application.
>>
>> Github project:  https://github.com/OneClickToQif/OneClickToQif
>>
>>
[snip]
> I downloaded two of the spreadsheets from GitHub, and I was able to open
> them with LibreOffice. Unfortunately they were not usable at all on my
> Linux system.
[snip]

> It looks like the VBA code includes Windows-only .dll functions (for the
> file selector), so this alone would make the spreadsheets usable only for
> Microsoft Excel in Windows. (I believe Excel on a Macintosh cannot use .dll
> functions.)
> 
> To make your utility more widely available to GnuCash users, you might
> research whether it's possible to use more generic VBA functions that can
> run under LibreOffice. (LibreOffice and its cousin OpenOffice are open
> source and freely available on Windows, Macintosh and Linux.)
>
+1

Since libreoffice can convert its spreadsheets to excel, just use
libreoffice to provide an excel version of your spreadsheet for
those users who don't want to install the free libreoffice on
their windows machines.

> Otherwise, you might clearly identify your project as being for Microsoft
> Windows and Microsoft Office only.
+2






More information about the gnucash-user mailing list