sql到textbox到excel(格式化)邮寄 [英] sql to textbox to excel (formatted) to mail
问题描述
我的表格很小
员工编号---文本框
员工姓名----文本框
员工部门----文本框
员工工资-----文本框
员工年龄----文本框
现在我有一个带有搜索文本框的网页
员工编号-----文本框(搜索crtiretia)
当用户键入员工编号时,所有sql数据均应填写包含员工姓名,工资,年龄,部门等信息的表格.
下一个
我有2个按钮
excel导出
自动邮件
在excel导出中,我具有指定的格式
我实际上需要的是什么
当我单击导出按钮文本框数据时,应发送到EXCEL文件
和特定的文本框数据应在特定的单元格中接收.
例如:-TEXTBOX1发送到C3或C4
文本框2发送G9
当我点击邮件按钮时
应将数据发送至附件并自动执行
,我有3个具有不同格式的EXCEL文件
导出按钮应使用其各自的数据查看所有EXCEL文件
和邮件按钮应向EXCEL文件发送DATA,其中1个用户I EXCEL文件
2ND USER 2ND EXCEL FILE
3RD USER 3 EXCEL FILE
请帮助,它非常紧急
并请使用完整的解决方案.
i have a small form
employeenumber ---textbox
employee name ---- textbox
employee department ---- textbox
employee sal ----- textbox
employee age ---- textbox
now i have a webpage with search textbos
employeenumber ----- textbox (search crtiretia)
when user types employee number all the sql realted data should fill the form conataineing employee name, sal, age , dept etc.
next
i have 2 buttons
excel export
automail
in excel export i have a specified format
WHAT I ACTUALLY NEED IS
WHEN I CLICK EXPORT BUTTON TEXTBOX DATA SHOULD BE SEND TO EXCEL FILE
AND PARTICULAR TEXTBOX DATA SHOULD BE RECEIVED AT PARTICULAR CELL.
E.G:- TEXTBOX1 TO SEND TO C3 OR C4
TEXTBOX 2 TO SEND G9
WHEN I CLICK MAIL BUTTON
THAT DATA SHOULD BE SEND TO EXCEL AND AUTOMAILED AS ATTACHMENT
, I HAVE 3 EXCEL FILES WITH DIFFERENT FORMATS
EXPORT BUTTON SHOULD VIEW ALL THE EXCEL FILES WITH THEIR RESPECTIVE DATA
AND MAIL BUTTON SHOULD SEND MAIL THE EXCEL FILES WITH DATA , 1 USER I EXCEL FILE
2ND USER 2ND EXCEL FILE
3RD USER 3 EXCEL FILE
PLEASE HELP , ITS VERY URGENT
AND PLEASE HELP WITH COMPLETE SOLUTION.
推荐答案
您好,请检查本文: ^ ]
Hi, please check this article: Exporting Data to Excel[^]
这篇关于sql到textbox到excel(格式化)邮寄的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!