Excel to Database through Servoy

Classic Servoy
1

Hi

Is there anyway to just cutand paste some of the data from a excel sheet in to servoy. if its possible how can I achieve that.

The situation is we constantly get the excel sheets which we have to import them in to SQL Database, and we have to print some details from the database as Barcode labels.

so I can’t use DTS option in SQL Server to update automatically as some of the primary key fields have null values in the excel sheet and we can’t avoid these, as these excel files comes from clients.

any idea is appreciated.

Thanks & Regards
Chandra Arumalla.

2

It is currently not possible to paste excel data, we could make an excel sheet(file) import plugin fairly easy…if that whould help

3

Jan Blok:
We could make an excel sheet(file) import plugin fairly easy…if that whould help

Hi Jan

Thanks for that that will be a great help. also one other small question.
my excel sheets comes with chemical formulas. if I import them to database are those can be retrived as same or like…

3C6H12)5-2HCl

I know SQL doesn’t hold subscripts and superscripts.Is there a way to make it possible… through SERVOY or any other means…

4

Excel import plugin is now on the planning

For the formula’s do the following:
make a calculation:
return ‘’+fieldWithFormula;
add the calculation as dataprovider to a field with type HTML_Area or to a Label, in both cases you will see the formula well formatted.

5

[u]Beta Excel plugin[/u] (extract in plugins dir)
Will be shipped with next build

6

You guys are the most responsive team I have ever seen!

That’s all, carry on…

dave lundgren