• XLSX Converter?

    From Richard Porter@21:1/5 to All on Sun Oct 17 22:02:30 2021
    Is there a RISC OS app that will convert .xlsx files?

    --
    Richard Porter

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Doug Webb@21:1/5 to Richard Porter on Sun Oct 17 22:46:33 2021
    In message <316e017d59.news@user.minijem.plus.com>
    Richard Porter <ricp@minijem.plus.com> wrote:

    Is there a RISC OS app that will convert .xlsx files?

    You need ViewXLS 0.23B by Anton Reiser which will load XLSX files and
    display them with restrictions.

    You can then save as TSV,CSV or Draw file format out of it.

    --
    Experience the future using ARM Technology - ARMBook,BeagleBoard -xM, PandaBoard,Raspberry Pi,iMX6/ARMX6,IGEPv5 & Titanium powered by RISC OS
    5.28.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dave@21:1/5 to Doug Webb on Mon Oct 18 07:20:42 2021
    In article <6a76057d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:
    In message <316e017d59.news@user.minijem.plus.com>
    Richard Porter <ricp@minijem.plus.com> wrote:

    Is there a RISC OS app that will convert .xlsx files?

    You need ViewXLS 0.23B by Anton Reiser which will load XLSX files and
    display them with restrictions.

    You can then save as TSV,CSV or Draw file format out of it.

    Interesting...

    I can get 'name/xls' files to display in ViewXLS 0.23B but I've not been
    able (Ever) to get a 'name/xlsx' file to view.

    Dave

    --

    Dave Triffid

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Doug Webb@21:1/5 to Dave on Mon Oct 18 11:07:54 2021
    In message <597d3488d4dave@triffid.co.uk>
    Dave <dave@triffid.co.uk> wrote:

    In article <6a76057d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:
    In message <316e017d59.news@user.minijem.plus.com>
    Richard Porter <ricp@minijem.plus.com> wrote:

    Is there a RISC OS app that will convert .xlsx files?

    You need ViewXLS 0.23B by Anton Reiser which will load XLSX files and
    display them with restrictions.

    You can then save as TSV,CSV or Draw file format out of it.

    Interesting...

    I can get 'name/xls' files to display in ViewXLS 0.23B but I've not been
    able (Ever) to get a 'name/xlsx' file to view.

    Dave
    Hi Dave,

    It does say it doesn't work on all and in particular multi-sheet ones.

    Also make sure your Mimemap is set up correctly.

    Tim Hill's version covers this off for XLSX files which should have a type &AF7.

    Also make sure you have the latest version as there were some changes
    made.

    Also you don't say which version of RISC OS you are running but I suspect
    it is under VRPC, so perhaps that is an issue?

    Finally have you reported/sent an example file that doesn't work to Anton?

    Take care.
    --
    Experience the future using ARM Technology - ARMBook,BeagleBoard -xM, PandaBoard,Raspberry Pi,iMX6/ARMX6,IGEPv5 & Titanium powered by RISC OS
    5.28.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Doug Webb@21:1/5 to Dave on Mon Oct 18 15:40:59 2021
    In message <597d5ff73fdave@triffid.co.uk>
    Dave <dave@triffid.co.uk> wrote:

    In article <ca55497d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:
    In message <597d3488d4dave@triffid.co.uk>
    Dave <dave@triffid.co.uk> wrote:

    [snip]

    The ViewXLS is version is 0.23b (17/03/2020) AFAIK the latest availiable.

    OK , There is a typo ,in the !Run file with in it..

    It says:

    Set File$Type_BA6 MSExcel
    Set File$Type_BA7 MSExcelX

    When it should be:

    Set File$Type_BA6 MSExcel
    Set File$Type_A7F MSExcelX

    So try amending the Run file, save it, reboot and try again.

    Also you don't say which version of RISC OS you are running but I
    suspect it is under VRPC, so perhaps that is an issue?

    VRPC-DL and RISC OS 6.20

    RPCEmu 0.9.3 and RISC OS 5.28

    Finally have you reported/sent an example file that doesn't work to
    Anton?

    Nothing to send, it just does nothing. :-(

    Well there is something as even if it is a simple file it should work work
    so may be as aan off chance I'd let Anton know and also include the
    versions of OS/Systems you have tried it on.

    Take care.
    --
    Experience the future using ARM Technology - ARMBook,BeagleBoard -xM, PandaBoard,Raspberry Pi,iMX6/ARMX6,IGEPv5 & Titanium powered by RISC OS
    5.28.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dave@21:1/5 to Doug Webb on Mon Oct 18 15:15:09 2021
    In article <ca55497d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:
    In message <597d3488d4dave@triffid.co.uk>
    Dave <dave@triffid.co.uk> wrote:

    In article <6a76057d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:
    In message <316e017d59.news@user.minijem.plus.com>
    Richard Porter <ricp@minijem.plus.com> wrote:

    Is there a RISC OS app that will convert .xlsx files?

    You need ViewXLS 0.23B by Anton Reiser which will load XLSX files and
    display them with restrictions.

    You can then save as TSV,CSV or Draw file format out of it.

    Interesting...

    I can get 'name/xls' files to display in ViewXLS 0.23B but I've not
    been able (Ever) to get a 'name/xlsx' file to view.

    Dave

    Hi Dave,

    It does say it doesn't work on all and in particular multi-sheet ones.

    It is a very simple and very small sheet of 8 cells.

    Also make sure your Mimemap is set up correctly.

    Tim Hill's version covers this off for XLSX files which should have a
    type &AF7.
    I've switched it on and added AF7

    Also make sure you have the latest version as there were some changes
    made.

    The Tim Hill MimeMap file is 21/03/21
    The ViewXLS is version is 0.23b (17/03/2020) AFAIK the latest availiable.

    Also you don't say which version of RISC OS you are running but I
    suspect it is under VRPC, so perhaps that is an issue?

    VRPC-DL and RISC OS 6.20

    RPCEmu 0.9.3 and RISC OS 5.28

    Finally have you reported/sent an example file that doesn't work to
    Anton?

    Nothing to send, it just does nothing. :-(

    Take care.

    Thanks, appreciate your thoughts.

    Dave

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dave@21:1/5 to Doug Webb on Mon Oct 18 16:22:28 2021
    In article <1a56627d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:

    [Snip]

    OK , There is a typo ,in the !Run file with in it..

    It says:

    Set File$Type_BA6 MSExcel
    Set File$Type_BA7 MSExcelX

    When it should be:

    Set File$Type_BA6 MSExcel
    Set File$Type_A7F MSExcelX

    So try amending the Run file, save it, reboot and try again.

    Aha! that sorted it... :-)

    Took a closer look at the !Run file and noticed it has a second reference
    to BA7

    Set Alias$@RunType_BA6 Run <ViewXLS$Dir>.!Run %%*0
    Set Alias$@RunType_BA7 Run <ViewXLS$Dir>.!Run %%*0

    Is that correct or should it also be changed?

    Thanks
    Dave


    [Snip]

    --

    Dave Triffid

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Doug Webb@21:1/5 to Dave on Mon Oct 18 16:58:14 2021
    In message <597d662285dave@triffid.co.uk>
    Dave <dave@triffid.co.uk> wrote:

    In article <1a56627d59.dougjwebb@btinternet.com>,
    Doug Webb <doug.j.webb@btinternet.com> wrote:



    When it should be:

    Set File$Type_BA6 MSExcel
    Set File$Type_A7F MSExcelX

    So try amending the Run file, save it, reboot and try again.

    Aha! that sorted it... :-)

    Good to know.

    Took a closer look at the !Run file and noticed it has a second reference
    to BA7

    Set Alias$@RunType_BA6 Run <ViewXLS$Dir>.!Run %%*0
    Set Alias$@RunType_BA7 Run <ViewXLS$Dir>.!Run %%*0

    Is that correct or should it also be changed?

    Yes forgot to mention that as well.

    Take care.

    --
    Experience the future using ARM Technology - ARMBook,BeagleBoard -xM, PandaBoard,Raspberry Pi,iMX6/ARMX6,IGEPv5 & Titanium powered by RISC OS
    5.28.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)