Click here to Skip to main content
15,920,005 members
Home / Discussions / C#
   

C#

 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
WebMaster2-Oct-09 6:46
WebMaster2-Oct-09 6:46 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
Saksida Bojan2-Oct-09 7:06
Saksida Bojan2-Oct-09 7:06 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
WebMaster2-Oct-09 20:59
WebMaster2-Oct-09 20:59 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
Saksida Bojan2-Oct-09 22:19
Saksida Bojan2-Oct-09 22:19 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
WebMaster3-Oct-09 1:01
WebMaster3-Oct-09 1:01 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
Saksida Bojan3-Oct-09 1:49
Saksida Bojan3-Oct-09 1:49 
GeneralRe: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized Pin
WebMaster3-Oct-09 4:34
WebMaster3-Oct-09 4:34 
Questionnot able to read data from excel sheet using Microsoft.Office.Interop.Excel Pin
PrasannaKulkarni2-Oct-09 4:34
PrasannaKulkarni2-Oct-09 4:34 
I do have code which is reading the data from an excel sheet properly. but have a weird issue.

If the excel sheet has a column containing long numbers data eg. 89.00000001 and if that column is not resized to its max, that cell is displaying "#####" if you open the excel sheet. So my application code is also reading it as "#####" instead of the correct data. If i resize that column to display the data properly and save, then my application code is reading the data correctly.

I can have my users to have the input excel sheet have all the columns maximized, but was wondering if there any way to have it done programmatically.

Do let me know.

My code snippet is :
// get data in cell
for (int i = 2; i <= iValue; i++)
{
dr = ds.Tables["dtExcel"].NewRow();
for (int j = 1; j <= jValue; j++)
{
oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i, j];
string strValue = oRng.Text.ToString();
dr[j-1] = strValue;
}
ds.Tables["dtExcel"].Rows.Add(dr);
}
return ds;

Thanks
Prasanna
AnswerRe: not able to read data from excel sheet using Microsoft.Office.Interop.Excel Pin
Dave Kreskowiak2-Oct-09 5:28
mveDave Kreskowiak2-Oct-09 5:28 
GeneralRe: not able to read data from excel sheet using Microsoft.Office.Interop.Excel Pin
PrasannaKulkarni2-Oct-09 6:19
PrasannaKulkarni2-Oct-09 6:19 
GeneralRe: not able to read data from excel sheet using Microsoft.Office.Interop.Excel Pin
Dave Kreskowiak2-Oct-09 7:05
mveDave Kreskowiak2-Oct-09 7:05 
QuestionCannot convert from system...IList<class> to class[]</class> Pin
Sevententh2-Oct-09 4:09
Sevententh2-Oct-09 4:09 
AnswerRe: Cannot convert from system...IList to class[] Pin
Keith Barrow2-Oct-09 4:19
professionalKeith Barrow2-Oct-09 4:19 
GeneralRe: Cannot convert from system...IList to class[] Pin
Sevententh5-Oct-09 23:27
Sevententh5-Oct-09 23:27 
QuestionOdd behaviour when selecting item in a Combobox [Fixed it, my fault] Pin
Anthony Mushrow2-Oct-09 4:07
professionalAnthony Mushrow2-Oct-09 4:07 
QuestionC# TCP networkstreem problem Pin
Titok Levi2-Oct-09 2:32
Titok Levi2-Oct-09 2:32 
AnswerRe: C# TCP networkstreem problem Pin
Luc Pattyn2-Oct-09 3:06
sitebuilderLuc Pattyn2-Oct-09 3:06 
AnswerRe: C# TCP networkstreem problem Pin
0x3c02-Oct-09 3:56
0x3c02-Oct-09 3:56 
AnswerRe: C# TCP networkstreem problem Pin
Tr@v2-Oct-09 16:26
Tr@v2-Oct-09 16:26 
GeneralRe: C# TCP networkstreem problem Pin
Titok Levi6-Oct-09 22:03
Titok Levi6-Oct-09 22:03 
QuestionGenerics, delegates and type inference Pin
dojohansen2-Oct-09 2:10
dojohansen2-Oct-09 2:10 
AnswerRe: Generics, delegates and type inference Pin
Gideon Engelberth2-Oct-09 6:29
Gideon Engelberth2-Oct-09 6:29 
GeneralRe: Generics, delegates and type inference Pin
dojohansen2-Oct-09 7:43
dojohansen2-Oct-09 7:43 
GeneralRe: Generics, delegates and type inference Pin
Gideon Engelberth2-Oct-09 13:00
Gideon Engelberth2-Oct-09 13:00 
QuestionInheritance question Pin
xkrja1-Oct-09 23:35
xkrja1-Oct-09 23:35 

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.