|
bluetx wrote: i dont want to work for me anybody what do you mean?i dont understand.r u drinking?
The question should be 'Are YOU drinking?' as what you have just said makes no sense.
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
bluetx wrote: if easy so you write for me here man
That is not the point, if people come here asking for advice and help then others will help. If people come here asking for people to write code for them because they are too lazy then others will kindly tell them where to go i.e. switching off the computer and going to teach sports.
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
you didnt understand me. i said write code if easy.its a gibe.you are very emotional.wake up 
|
|
|
|
|
You sir, are a tool.
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
I'm not your dog man, try by your own or transfer cash to my account and perhaps i'll do it.
good luck
|
|
|
|
|
if i will send you money,you are my dog? 
|
|
|
|
|
No, he would then be an employee.
One of three things is going to happen here, you tool.
Firstly, you will fail your course, if you are taking one.
Secondly, you will not complete your project, which is comparable to point one.
Thirdly, your employer will fire you or your employer will terminate your contract if your obligations rest on one point.
Either way, you fail.
I'd suggest checking out rentacoder.com, it is a website where you can pay to have work done. You won't find your answer anywhere else unless you code your own logic or pay for it.
|
|
|
|
|
i found my answer.
i shared,may be its helpfull who need him.
var enumerationList = x.Select(s => s.Split(',')).GroupBy(s => s[0], s => s[1]);
bye bye M$ guys
|
|
|
|
|
bluetx wrote: bye bye
Don't let the door hit you in the ass on the way out.
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
Don't bother, this guy is walking into failure. His project / goals won't be accomplished with his attitude. He may get a line of code, but the overall project is destined for failure under his guidance.
|
|
|
|
|
I concur
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
yes here shopping i forgetten i closed door back idiot
|
|
|
|
|
bluetx wrote: its a gibe.you are very emotional.wake up
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
yes yes advice and after you send me money.
yeah go to hell.
|
|
|
|
|
|
While I appreciate your remark was probably intended as a joke, it was in poor taste. These boards are for advice. Asking for code is very bad form, and may result in a refusal to help, being put on a hit list, getting flamed or one or more of the above
|
|
|
|
|
can neone help me with importing data from a xls file to an array ... i am not using databases and i want it to be importes into an array in c# class 
|
|
|
|
|
Where did you get stuck? Seems pretty straight forward...
|
|
|
|
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
I am learning to use c# at the moment .. i have this code to read an excel file ... its incomplete now asi am yet to define the other varibles but as of now i want to have a user input in textbox1 and then that is to be the file name of the excel file to open ... can ne one help me
namespace WindowsFormsApplication7
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
try
{
// open the users excel workbook.
Excel.Application ExcelApp = new Excel.ApplicationClass();
ExcelApp.Visible = true;
String WorkbookPath = "c:/Users/Guchu/Desktop/a.xls";
Excel.Workbook ExcelWorkbook = ExcelApp.Workbooks.Open(WorkbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true,false,0,true,false,false);
Excel.Sheets excelSheets = ExcelWorkbook.Worksheets;
string CurrentSheet = "CurrentSheet";
excelSheets = (Excel.Sheets) excelSheets.get_Item(CurrentSheet);
}
catch (Exception theException)
{
String errorMessage;
errorMessage = "Error: ";
errorMessage = String.Concat(errorMessage, theException.Message);
errorMessage = String.Concat(errorMessage, " Line: ");
errorMessage = String.Concat(errorMessage, theException.Source);
MessageBox.Show(errorMessage, "Error");
}
}
private void button2_Click(object sender, EventArgs e)
{
}
}
}
|
|
|
|
|
Why not just use the process class with the start method to instantiate excel.exe to open with your workbook in question?
|
|
|
|
|
as i have told u that i am new to c# hence i might have done it the harder way ... but it will be easy for me to understand if u can give me the code ...
what i did was ...
for the text box i wrote...
this.textbox1 = new system.windows.forms.textbox();
string a = textbox1.text,
then in the button 1 part for opening the code i want to insert this string a as the file name in the file path
string workbookpath = @ "c:\.....\" + a ;
but this doesnt works ... can u tell me the correct way
|
|
|
|
|
guchu wrote: this.textbox1 = new system.windows.forms.textbox();
string a = textbox1.text,
A new textbox would be blank, so string a would be "", debug through your code.
I will not give you the code but go to the documentation[^] and check out the process class, specifically the start method, and search the forums a bit, you'll find your answer. You just have to research for it.
Also, I would look into the OpenFileDialog to pick your file, that way you have no restriction on the residual location of your excel files.
|
|
|
|
|
i understand that u want me to learn the easier method but even using this one i am able to open the file if i specify the file name as "C:\....\a.xls" ... all i want to know is if i want to take this last part(a.xls) from the user since the file neways has to be on the desktop then how do i accomodate it in the code ... i have tried doing it using the + operator but it is not done this way as it seems as the compiler doesnt reads the remaining thing written outside "" ... i would be obliged if u can help ... i need it desperately
|
|
|
|
|
You reset your textbox by doing Textbox1 = new System.Windows.Forms.Textbox();
if you take that out, you should be fine provided the file exists but your design is horrible, inefficient and there is a faster, prettier way of doing it.
|
|
|
|
|
I will go through the documentation and redesign the program .... i will get back to u if i have any quaries regarding this ... as of now thank you very much for helping me out ....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
