如何在excel打印中获取时间格式 [英] How do I get time format in excel print

问题描述

我的代码没有给我excel.time的所有数据都没有这种格式给出...

如果我在Excel中打印时间，它不打印..请帮助我

my code is not giving me all data in excel.time is not given by this format...
if i print time in excel ,its not printing..please help me

protected void lbDownload_Click(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        try
        {
            dt = BindDailyReport();
            if (dt.Rows.Count > 0)
            {
                string filename = "AttendanceSheet(" +txtFromDate.Text + ").xls";
                string attachment = "attachment; filename=" + filename;
                Response.ClearContent();
                Response.AddHeader("content-disposition", attachment);
                Response.ContentType = "application/ms-excel";
                StringWriter stw = new StringWriter();
                HtmlTextWriter htextw = new HtmlTextWriter(stw);
                DataGrid dgGrid = new DataGrid();
                dgGrid.DataSource = dt;
                dgGrid.DataBind();
                dgGrid.RenderControl(htextw);
                //gdvAttendance.RenderControl(htextw);
                Response.Write(stw.ToString());
                Response.End();
            }
        }
        catch (Exception ex)
        {
        }
        finally
        {
        }
    }
    public override void VerifyRenderingInServerForm(Control control)
    {

    }

推荐答案

您好，



我认为打字数据集可以帮助您解决问题。 ..



谢谢，

Ullas

Hi,

I think typed data set may help you to solve the issue...

Thanks,
Ullas

我通过转换解决了这个问题日期时间格式。因为DataGrid不支持09:00:00格式的时间..

谢谢大家好看。

I've solved this...by converting the date time format. Because DataGrid does not support 09:00:00 format of time ..
thank u all for being nice.

这篇关于如何在excel打印中获取时间格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！