obamaself Posted June 29, 2012 at 08:52 AM Report #466339 Posted June 29, 2012 at 08:52 AM 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
jlpcalado Posted June 29, 2012 at 11:19 AM Report #466403 Posted June 29, 2012 at 11:19 AM Podes colocar contorno na célula: objExcelSheet.Cells(dgvRowIndex, dgvCellIndex).BorderAround(, XlBorderWeight.xlMedium) - há outras opções.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now