的FileStream - "不支持&QUOT给定的路径的格式; [英] FileStream - "The given path's format is not supported"
问题描述
我想使用 EPPlus 保存为我们的LAN preadsheet。我使用的是的FileStream
对象要做到这一点,但是每当我尝试实例,我得到了错误的对象
不支持给定路径的格式
C#
私有静态字符串_filename =ErroredRows_;
私人静态字符串_results =
@"\\prdhilfs03\l&i-sales&mkt\WORKAREA\Agencyservices\Shared\AIC\Analysts_and_Reporting\Realignments\2014\MassUpdateTesting\Results\";
公共静态无效写入preadsheet(词典< DataRow的,串GT;错误)
{
//创建下载目标
字符串的文件路径= System.IO.Path.Combine(_results,_filename + DateTime.Now.ToString(YYYY-MM-dd_HH:MM:SS)+的.xlsx);
的FileStream NEWFILE =新的FileStream(文件路径,FileMode.Create,FileAccess.Write);
//构造新的Excel包
ExcelPackage PCK =新ExcelPackage(NEWFILE);
//实例化工作簿对象
变种WS = pck.Workbook.Worksheets.Add(查询1);
这里的文件路径
字符串的内容
变量。
这行抛出上述错误:
的FileStream NEWFILE =新的FileStream(文件路径,FileMode.Create,FileAccess.Write);
您不能有:
在你的文件名或路径
我会做什么,如果我是你,是这样的:
DateTime.Now.Ticks.ToString()
而不是
DateTime.Now.ToString(YYYY-MM-dd_HH:MM:SS)
无论如何,你可以保持你自己的逻辑,但你必须删除:
(而不是使用 -
或 _
为例)
I'm trying to use EPPlus to save a spreadsheet on our LAN. I'm using a FileStream
object to do this, however whenever I attempt to instantiate the object I get the error
The given path's format is not supported
C#
private static string _fileName = "ErroredRows_";
private static string _results =
@"\\prdhilfs03\l&i-sales&mkt\WORKAREA\Agencyservices\Shared\AIC\Analysts_and_Reporting\Realignments\2014\MassUpdateTesting\Results\";
public static void WriteSpreadsheet(Dictionary<DataRow, string> errors)
{
//Create download Destination
string filePath = System.IO.Path.Combine(_results, _fileName + DateTime.Now.ToString("yyyy-MM-dd_HH:mm:ss") + ".xlsx");
FileStream newFile = new FileStream(filePath, FileMode.Create, FileAccess.Write);
//Construct new Excel package
ExcelPackage pck = new ExcelPackage(newFile);
//Instantiate workbook object
var ws = pck.Workbook.Worksheets.Add("Query1");
Here's the contents of the filePath
string
variable.
\\\\prdhilfs03\\l&i-sales&mkt\\WORKAREA\\Agencyservices\\Shared\\AIC\\Analysts_and_Reporting\\Realignments\\2014\\MassUpdateTesting\\Results\\ErroredRows_2014-01-30_13:46:33.xlsx
This line throws the error mentioned above:
FileStream newFile = new FileStream(filePath, FileMode.Create, FileAccess.Write);
You can't have :
in your filename or path.
What i would do if i were you is this:
DateTime.Now.Ticks.ToString()
instead of
DateTime.Now.ToString("yyyy-MM-dd_HH:mm:ss")
Anyway, you can keep your own logic but you have to remove :
(instead use -
or _
for example)
这篇关于的FileStream - &QUOT;不支持&QUOT给定的路径的格式;的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!