specify file name and path in streamwriter

Matthew Pawelke

I want to create a new notepad file and specifiy file location and name i have: i'm getting an error that says empty path name is illegal
SaveFileDialog saveFile = new SaveFileDialog();
string filePath = saveFile.FileName;
StringBuilder sb = new StringBuilder();
if (saveFile.ShowDialog() == DialogResult.OK)
{
... assign data to string
}
StreamWriter sw = new StreamWriter(filePath);
sw.WriteLine(sb);
sw.Close();

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

PJ Martins16y ago
No problem, if you could mark one of these as the answer that would be helpful.

Thanks,
PJ
Matthew Pawelke16y ago
awesome! thanks so much for all the help! i think it's finally finished, i'll post monday if i have more questions
PJ Martins16y ago
Remvoe the quotation marks from
StreamWriter sw = new StreamWriter("filePath");

to
StreamWriter sw = new StreamWriter(filePath);
Matthew Pawelke16y ago

private void orderReceiptToolStripMenuItem_Click(object sender, EventArgs e)
{
// error handling
if (txtOrderNumber.Text == "")
{
MessageBox.Show("Please enter order number first!", "PowerKage Inventory", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "Text Files(*.txt)|*.txt";
StringBuilder sb = new StringBuilder();
if (saveFile.ShowDialog() == DialogResult.OK)
{
string filePath = saveFile.FileName;
string orderNumber = txtOrderNumber.Text;
int sheetNum = xlWorkBook.Worksheets.Count;
string description = richTextBoxDescription.Text;
sb.AppendLine("Transaction Receipt\t\t\t" + orderNumber);
sb.AppendLine("------------------------------------------------------------------------------");
sb.AppendLine("");
sb.AppendLine(description);
sb.AppendLine("\t \t \t \t \t Purchased\t \t Sold");
sb.AppendLine("Date \t \tComponent\tCost\t Qty\tValue\t \tQty\tValue");
// loop through sheets
for (int i = 1; i < sheetNum; i++)
{
xlWorkSheet = (Excel.Worksheet)xlSheets.get_Item(i);
chartRange = xlWorkSheet.UsedRange;
int rowCount = chartRange.Rows.Count;
// loop through rows
for (int counterVar = 2; counterVar < rowCount; counterVar++)
{
string counterColumn = Convert.ToString((chartRange.Cells[counterVar, 2] as Excel.Range).Value2);
if (counterColumn == orderNumber)
{
sb.AppendLine(Convert.ToString((chartRange.Cells[counterVar, 3] as Excel.Range).Text) + "\t" +
Convert.ToString((chartRange.Cells[1, 1] as Excel.Range).Value2) + "\t\t$" +
Convert.ToString((chartRange.Cells[counterVar, 7] as Excel.Range).Value2) + "\t " +
Convert.ToString((chartRange.Cells[counterVar, 5] as Excel.Range).Value2) + "\t$" +
Convert.ToString((chartRange.Cells[counterVar, 9] as Excel.Range).Value2) + "\t \t" +
Convert.ToString((chartRange.Cells[counterVar, 6] as Excel.Range).Value2) + "\t $" +
Convert.ToString((chartRange.Cells[counterVar, 10] as Excel.Range).Value2));
}
}
}
// write to file
StreamWriter sw = new StreamWriter("filePath");
sw.WriteLine(sb);
sw.Close();
}
}
}
PJ Martins16y ago
Please attach the entire block of code you're working with so I may take a look.
Matthew Pawelke16y ago
but even saving a renaming a new file in my documents folder as test.txt or whatever once i save it and exit the program the file isn't there
PJ Martins16y ago
the filter will set your program to save any files from here on as .txt, files you already saved before making the code change will need to be manually renamed.
Matthew Pawelke16y ago
ok, that's what i thought i was just seeing if there was any way around it, but the saveFile.Filter = "Text Files(*.txt)|*.txt"; line didn't work
PJ Martins16y ago
This seems like normal behavior for an excel file that large, my only suggest would be to run this process in a background thread as to not slow your application down.
Matthew Pawelke16y ago
the file i'm printin is only a few lines long, 20 or so, but the excel file i'm reading from is 36 sheets adn 150 rows/sheet. each row doesn't have data right now since its a new file but i made it 150 so it can grow. right now i'm looping through rows i<150 to protrect against a null cell that isn't the end of the file, if i make it shorter its quicker but then not as versatile
PJ Martins16y ago
Add the following line after declaring your save dialog:
saveFile.Filter = "Text Files(*.txt)|*.txt";
How big is the file that you are printing?
Matthew Pawelke16y ago
thanks, that works but its not in .txt format, i get an open with dialog box and if i select notepad its fine but how do i set it to open with notepad automatically, also my print method from before is working fine now but its really slow, take about 8 - 10 secs after i click print till the menu drop down box goes away and the file is actually written, any suggestions?
PJ Martins16y ago
you need to set your filePath after .ShowDialog() and move your StreamWriter code to inside your if statement ie:
SaveFileDialog saveFile = new SaveFileDialog();
StringBuilder sb = new StringBuilder();
if (saveFile.ShowDialog() == DialogResult.OK)
{
string filePath = saveFile.FileName;
... assign data to string
StreamWriter sw = new StreamWriter(filePath);
sw.WriteLine(sb);
sw.Close();
}