jueves, 8 de abril de 2010

Reportes en Excel en Visual Basic

Hola amigos
en este codigo lo que hace es cojer un archivo de excel abrirlo y llenar los datos que necesito como mi reporte. Para esto utilizo 3 dll que son:

-Interop.Microsoft.Office.Core.dll
-Microsoft.Office.Interop.Excel.dll
-Microsoft.Vbe.Interop.dll

con estas 3 dll son con las que e realizado la aplicacion

y el codigo completo es el siguiente:

Imports Microsoft.Office.Interop
---------------------------------------------------------------------------------
Dim ruta As String = Application.StartupPath + "\rptpermiso.xls"
Dim excelApp As New Excel.Application()
Dim excelBook As Excel.Workbook = excelApp.Workbooks.Open(ruta)
Dim excelWorksheet As Excel.Worksheet = _
CType(excelBook.Worksheets(1), Excel.Worksheet)
excelApp.Visible = True
With excelWorksheet
.Name = "REPORTE DE PERMISOS"
.Tab.ColorIndex = 24
.Range("C" & 6).Value = "Este es Mi Reporte"
.Range("C" & 6).Font.Bold = True
.Range("C" & 6).Font.Size = "18"
.Range("C" & 6).Font.Name = "Monotype Corsiva"
.Range("C" & 6).Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter
End With
-------------------------------------------------------------------------------------

Preguntas o Comentarios ponganlo en mi Blog :D

Saludos
Victor Altamirano Vasquez

8 comentarios:

Anónimo dijo...

Hola saludos,
como podria pasar ese codigo a c# ya que necesito hacer un reporte en xls pero asp.net

gracias y saludos

Anónimo dijo...

Hurrah! Finally I got a website from where I be capable of really get useful facts concerning my study and
knowledge.

Here is my web blog http://mikrotik.net.pl/wiki/U%C5%BCytkownik:KrystalMa

Anónimo dijo...

If some one wants to be updated with newest technologies after that he must be pay a visit this web page and be up to date everyday.


Here is my web site - directory.winterparkdirect.info

Anónimo dijo...

It's an awesome article in support of all the online viewers; they will obtain advantage from it I am sure.

Also visit my blog :: las vegas golf schools

Anónimo dijo...

Helpful information. Lucky me I discovered your web site unintentionally, and I'm shocked why this twist of fate did not happened earlier! I bookmarked it.

Also visit my homepage http://chiropractors3.com/

Anónimo dijo...

Hello there! Do you know if they make any plugins to protect
against hackers? I'm kinda paranoid about losing everything I've worked hard on.

Any suggestions?

Check out my web site: Orlando Chiropractor

Anónimo dijo...

My partner and I absolutely love your blog and find most of your post's to be just what I'm
looking for. Does one offer guest writers to write content for you personally?
I wouldn't mind creating a post or elaborating on many of the subjects you write regarding here. Again, awesome web log!

my website; sciatica relief magnilife

Anónimo dijo...

Attractive section of content. I just stumbled upon
your blog and in accession capital to assert that I acquire actually
enjoyed account your blog posts. Any way I'll be subscribing to your feeds and even I achievement you access consistently rapidly.

My homepage - middle back pain causes and treatment