问题描述
我想阅读每种类型格式的工资单。我试图读取各种类型格式的Payslip(SalarySlip,PaymentSlip)并插入到数据库中。但到目前为止我无法完美地完成它。请建议我最好的方式来阅读数百种类型的薪资福利
提前感谢
感谢回复Sir ...我特此更新我的问题
1.我有很多excel表工资单,信息如下
I want to read payslip of each type format.I tried to read excel of various type format of Payslip(SalarySlip,PaymentSlip) and insert to in database .But till now I am not able to do it perfectly.Please suggest me best way to read excel of hundreds types payslip
thanks in advance
thanks for reply Sir ..I hereby updating my question
1. I have lots of excel sheet payslip having information like below
Employee Name :Suresh Emp Code --E01
Bank Ac/No :1564564654
EARNINGS| AMOUNT | DEDUCTION | AMOUNT
----------------------------------------------
BASIC | 65,800.00 | PT | 200,00
----------------------------------------------
HRA | 500.OO | PF | 1500
----------------------------------------------
另一个工资单
another payslip
Employee Name :Rajesh Emp Code --D11
Bank Ac/No :456465654
EARNINGS AMOUNT | DEDUCTION| AM
------------------------------------------
BASIC 25,800.00 | PT | 200,00
--------------------
HRA 700.OO | PF | 1500
------------------------------------------
Employee Name :Amol Emp Code --AP002
Bank Ac/No :3212313
EARNINGS AMOUNT | DEDUCTION| AMOUNT
------------------------------------------
BASIC 23,600.00 | PT 200,00
--------------------------------------------
HRA 700.OO | PF | 1500
------------------------------------------
Employee Name :Ojas Emp Code --OP0334
Bank Ac/No :78787878
EARNINGS AMOUNT | DEDUCTION| AM
------------------------------------------
BASIC HRA 23,600.00 700 | PT PF | 200,00 1500
--------------------------------------------
| PF | 1500
------------------------------------------
现在这个数据中的payslip示例没有合并到一个excel中。在另一个paslip数据合并但合并的类型不同是在最后三个palyslip中有所不同。
现在采取的措施
1.我使用oledb连接在C#编程中的数据表中导入这些数据。
2.然后我尝试读取每个单元格数据并插入到payslip表中。但是你看到的问题是最后三个以不同格式合并的payslip单元格值。在Rajesh中,payslip单元收益并且其金额合并在单个单元格中。
而在Amol payslip中,Deduction列的第一个头值与其金额合并。在Ojas中,薪资单的收入头彼此合并,并且价值在不同单元格。
像这样我看到了很多工资单,我需要找到最好的方法来从这些类型的Excel中获取最大数据,并且效率和性能都很好。
请你建议吗?如果你想看到工资单图像,那么我也可以为此显示图像我需要你的电子邮件ID。再次感谢....
我尝试过什么:
为此,我在这个论坛上提出了问题。基于这个答案的分析我制作了算法并为此创建了逻辑。但即使在创建算法之后我也是如此在excel shell数据合并时,特别是在读取salaryslip的某些部分时会失败。
now this payslip example in this data not merged in one excel .In another paslip data is merged but type of Merging is different is different in every last three palyslip .
Now Steps Taken By
1. I import this data in datatable in C# programming using oledb connection.
2. Then I tries to read every cell data and insert into payslip table.But problem as you see here last three payslip cell values merged in different formats . In Rajesh payslip cells Earning and with its amount merged in single cell .
Whereas in Amol payslip First head value of Deduction column merged with its amount.In Ojas payslip earning heads merged with each other and values in different cell.
Like this I saw lots of payslip I need to find best way to capture maxmimum data from these type excel with efficiently and good performance .
Will you please suggest ?If you want to see payslip image then I can show images also for this i need your email id.Thanks again....
What I have tried:
For this I asked questions on this forum .Analysis based on this answers i made algorithm and created logic for this .But even after creating alogorithm I become unsuccessfull in some part of reading salaryslip specially when excel shell data merged .
推荐答案
这篇关于各种格式的阅读工资单的算法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!