Jump to content

Exportar para excel


obamaself
 Share

Recommended Posts

Boas ao exportar para excel, tenho de modificar a cor de fundo das células.

Mas ao modificar a cor, os limites das células desaparecem :S

 With objExcelSheet.Cells(dgvRowIndex, dgvCellIndex).interior
	    If cell.Style.BackColor = Color.Red Then
					    .Color = Color.Red
				    Else
					    .color = Color.White
				    End If
End With

Ficam assim:

http://img825.imageshack.us/img825/8765/errosfw.jpg

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site you accept our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.