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:
Hola saludos,
como podria pasar ese codigo a c# ya que necesito hacer un reporte en xls pero asp.net
gracias y saludos
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
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
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
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/
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
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
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
Publicar un comentario