Excel Import

Classic Servoy
1

Hi

I need import from excel and I want use the excel import of Servoy but I have hidden the Servoy toolbar

Are there any option for call to Servoy excel import through a method?

Thanks

2

Juan,

This is currently not possible, but is planned for Servoy 6.

Rob

3

Hi Juan Martin.

Use VBScript or OLEPlugin to convert the excel sheet to a csv file, then import it from a regular method.

Best regards. Roberto Blasco.

4

Hi JuanMartin

Try this plugin.

Made it with JExcelApi

Best regards. Roberto Blasco.

JFlex.zip (656 KB)

5

You can also try our Data Plug-in.

It also makes it possible to export to various versions of excel and includes writing and reading of formatting, formulas etc.

You can read more about it here: http://www.servoycomponents.com/plugins/data.php

6

This is currently not possible, but is planned for Servoy 6.

Rob…has this been implemented in Serovy 6? If so, where are the instructions? The Servoy Wiki only refers to exporting data to Excel.

7

Kim,

This hasn’t been done unfortunately.
Best to create a feature request in our support system.

Rob

8

rgansevles:
Kim,

This hasn’t been done unfortunately.
Best to create a feature request in our support system.

Rob

Hi Rob,

Done deal. Feature request SVY-3454.

Cheers,
Maria

9

Thanks, Maria, for creating the feature request. I added my vote to the request.

10

kwpsd:
Thanks, Maria, for creating the feature request. I added my vote to the request.

+1

11

JuanMartin:
Hi

I need import from excel and I want use the excel import of Servoy but I have hidden the Servoy toolbar

Are there any option for call to Servoy excel import through a method?

Thanks

Juan Martin,

I actually found a workaround. It’s kind of wacky as David stated a while ago, but it does the job.

This is what I do:

function openMenuToImportAndExport(){
//globals.showUnderConstructionMessage();
plugins.dialogs.showWarningDialog(“Warning”,“yada yada … use with care”,“Ok”);
plugins.window.getMenuBar().reset();
plugins.window.getMenuBar().getMenu(0).doClick();
plugins.window.getMenuBar().removeAllMenus();
}

Basically, the method ‘openMenuToImportAndExport’ makes available the menu bar, and then ‘programmatically’ click the menu using the window plugin (which has the doClick() function in the node). The menu opens and stays open - as shown in the image below. There you can see the import and export built-in capabilities of Servoy :-)

[attachment=0]import_print_export_with_hidden_menu.JPG[/attachment]

In this way you have: the neat effect of keeping the window without the menus that we don’t use and use the quite good import, export and print functions of Servoy.

Carlos

import_print_export_with_hidden_menu.JPG
import_print_export_with_hidden_menu.JPG747×566 113 KB