Click here to Skip to main content
15,868,016 members
Home / Discussions / C#
   

C#

 
AnswerRe: Need to Change DatagridView POP background color from Vincenzo Rossi Pin
OriginalGriff27-Feb-20 20:33
mveOriginalGriff27-Feb-20 20:33 
QuestionOutlookaddin Pin
Member 1475442324-Feb-20 19:26
Member 1475442324-Feb-20 19:26 
AnswerRe: Outlookaddin Pin
OriginalGriff24-Feb-20 20:28
mveOriginalGriff24-Feb-20 20:28 
GeneralRe: Outlookaddin Pin
Member 1475442324-Feb-20 22:01
Member 1475442324-Feb-20 22:01 
GeneralRe: Outlookaddin Pin
OriginalGriff24-Feb-20 22:16
mveOriginalGriff24-Feb-20 22:16 
GeneralRe: Outlookaddin Pin
Member 1475442324-Feb-20 22:20
Member 1475442324-Feb-20 22:20 
GeneralRe: Outlookaddin Pin
OriginalGriff24-Feb-20 22:42
mveOriginalGriff24-Feb-20 22:42 
QuestionHow do I remove double quotes from Excel cell when data is exported to Excel in VB code? Pin
Member 1140330424-Feb-20 7:46
Member 1140330424-Feb-20 7:46 
I need help to fix an issue where when data from web application is exported to Excel by clicking a button export to excel, if the data in a cell contains double quotes, that data should be displayed without the double quotes visible.

Previously I made a change to the application code in VB so that the output exports text fields with formulas (="") to force Excel to treat those values as a string. This has been working except some instances where the output actually displays the formula characters (="") within the cell as text, rather than as hidden formulas. It appears when a cell contains text with an actual double quotes that is when after export to Excel is done, those quotes appear in Excel. I need help to figure out if there is a way to suppress those.

For example. A cell with the following data Allows the user the abilities to Add, View, Modify and Delete Notes on the Notes Tab of the Case Record. "View" allows the user to view the Notes Tab of the Case Record.

When this is exported to Excel the data is displayed as follows ="Allows the user the abilities to Add, View, Modify and Delete Notes on the Notes Tab of the Case Record. "View" allows the user to view the Notes Tab of the Case Record. I do not want to quotes to appear in Excel.

On the other hand, a cell with the following data Maintain Victim Classification Types. when this is exported to Excel there are no visible quotes. It displays as Maintain Victim Classification Types.

Here is my VB code that needed changing

VB
Dim row As DataRow
            'Loop through the datatable's rows
            For Each row In dt.Rows
                'Newline between the previous row and the next row
                sw.Write(vbNewLine)

                Dim column As New DataColumn()
                'Loop through each column and write the cell the the stringwriter
                For Each column In dt.Columns
                    'If the cell isn't empty write it, else write an empty cell
                    If Not row(column.ColumnName) Is Nothing Then
                        'WK Old code sw.Write(row(column).ToString().Trim() + vbTab)
                        'WK new 10/03/2019 
                        'To fix Marsha issue where preceding zero is truncated when export to Excel is processed. 
                        'This line of code enables the SQL query to return the numbers as unchanged strings, not numbers
                        sw.Write("=""" & row(column).ToString().Trim() & """" & vbTab)
                    Else
                        sw.Write(String.Empty + vbTab)
                    End If
                Next column
            Next row


modified 24-Feb-20 14:44pm.

AnswerRe: How do I remove double quotes from Excel cell when data is exported to Excel in VB code? Pin
Richard Deeming24-Feb-20 8:49
mveRichard Deeming24-Feb-20 8:49 
AnswerRe: How do I remove double quotes from Excel cell when data is exported to Excel in VB code? Pin
jsc4229-Feb-20 11:13
professionaljsc4229-Feb-20 11:13 
QuestionC# Pin
Member 1475231922-Feb-20 2:35
Member 1475231922-Feb-20 2:35 
AnswerRe: C# Pin
OriginalGriff22-Feb-20 4:21
mveOriginalGriff22-Feb-20 4:21 
QuestionC# string comparison ignoring diacritics, except unicode half-space (\u200c) Pin
Ayub Kokabi20-Feb-20 23:25
Ayub Kokabi20-Feb-20 23:25 
AnswerRe: C# string comparison ignoring diacritics, except unicode half-space (\u200c) Pin
Gerry Schmitz21-Feb-20 6:11
mveGerry Schmitz21-Feb-20 6:11 
GeneralRe: C# string comparison ignoring diacritics, except unicode half-space (\u200c) Pin
Ayub Kokabi21-Feb-20 7:37
Ayub Kokabi21-Feb-20 7:37 
GeneralRe: C# string comparison ignoring diacritics, except unicode half-space (\u200c) Pin
Gerry Schmitz21-Feb-20 8:07
mveGerry Schmitz21-Feb-20 8:07 
Questionquery to a xml database Pin
devilonline119-Feb-20 15:57
devilonline119-Feb-20 15:57 
AnswerRe: query to a xml database Pin
OriginalGriff19-Feb-20 20:04
mveOriginalGriff19-Feb-20 20:04 
GeneralRe: query to a xml database Pin
devilonline120-Feb-20 8:59
devilonline120-Feb-20 8:59 
GeneralRe: query to a xml database Pin
Richard Deeming21-Feb-20 0:55
mveRichard Deeming21-Feb-20 0:55 
AnswerRe: query to a xml database Pin
F-ES Sitecore19-Feb-20 23:08
professionalF-ES Sitecore19-Feb-20 23:08 
AnswerRe: query to a xml database Pin
Alkimus15-Mar-20 5:16
professionalAlkimus15-Mar-20 5:16 
QuestionSystem.Web.Services.Protocols.SoapException: Format of the initialization string does not conform to specification starting at index 97. Pin
Member 1474982719-Feb-20 15:36
Member 1474982719-Feb-20 15:36 
QuestionHow to do left and inner join in same query Pin
Mou_kol19-Feb-20 9:34
Mou_kol19-Feb-20 9:34 
AnswerRe: How to do left and inner join in same query Pin
Gerry Schmitz19-Feb-20 12:13
mveGerry Schmitz19-Feb-20 12:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.