Import an Excel table into Genexus

Asked

Viewed 520 times

1

I started messing with Genexus recently due to my internship, I need to pass the information from an Excel spreadsheet to GX to use in BD.

I am aware of a Pattern that does this, but it is still in beta and only has compatibility until certain version of GX 15, and I am recently using Trial 16.

excel genexus

1 answer

0

Good morning. You can read the Excel spreadsheet with Genexus programming commands and go fed your table into the database. The programming is done from the creation of a variable of type Exceldocument. For you have idea see two materials:

https://wiki.genexus.com/commwiki/servlet/wiki?33755,Generating+Excel+and+Word+Documents+%28X+Evolution+3%29,

http://treinamentodash.blogspot.com/2008/05/upload-de-arquivos-e-leitura-de-arquivo.html

This will give you a basis. If you have doubts, post again that I help you.

Good job!

  • The guides are good, but not exactly what I need, one of them is about generating XML documents with GX, the other to read tables without using MS Office. I have an XML table with information I would like to use I could insert it manually in KB but that would take a long time, so I would like to insert it directly, similar to what is shown in this video (https://www.youtube.com/watch?v=yVvcbS72y_A) Of course I don’t need it to be so practical, but something similar

  • Hello Vinicius, show me your code for reading the Excel spreadsheet. So I can help you better.

Browser other questions tagged excel genexus

You are not signed in. Login or sign up in order to post.