public void ImageTag(Document doc, SheetInfo info, ViewPortInfo vport) { // Create a new QRCoder Tag QRCoder.QRCodeGenerator qrGenerator = new QRCoder.QRCodeGenerator(); // Generate a new QR Tag QRCoder.QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(data, QRCoder.QRCodeGenerator.ECCLevel.M); // Assemble a temp file name string tempfile = System.IO.Path.GetTempFileName() + ".QRTAG"; // Get the Tags graphics element System.Drawing.Bitmap bmp = qrCode.GetGraphic(5); // Save it temporarily bmp.Save(tempfile); // Get the related view sheet View sheet = (View)doc.GetElement(info.sheetId); // Create a image element to return from import Element imageElement = null; // Get the Viewports label outline Outline labelOutline = vport.vport.GetLabelOutline(); // Get the lower left corner XYZ labelCorner = new XYZ(info.sheet.Origin.X + (labelOutline.MinimumPoint.X), info.sheet.Origin.Y + labelOutline.MinimumPoint.Y, 0); // Add some distance value XYZ location = labelCorner.Add(new XYZ(0, -0.5 / 12.0, 0)); // Import the image doc.Import(tempfile, new ImageImportOptions() { RefPoint = location, Placement = BoxPlacement.TopLeft }, sheet, out imageElement); // Delete temp file if (System.IO.File.Exists(tempfile)) { System.IO.File.Delete(tempfile); } }
protected void btngenerate_Click(object sender, EventArgs e) { string code = txtcode.Text; QRCoder.QRCodeGenerator qrgen = new QRCoder.QRCodeGenerator(); QRCoder.QRCodeGenerator.QRCode qrcode = qrgen.CreateQrCode(code, QRCoder.QRCodeGenerator.ECCLevel.Q); System.Web.UI.WebControls.Image imgqrcode = new System.Web.UI.WebControls.Image(); imgqrcode.Height = 150; imgqrcode.Width = 150; using (Bitmap bitmap = qrcode.GetGraphic(20)) { using (MemoryStream ms = new MemoryStream()) { bitmap.Save(ms, System.Drawing.Imaging.ImageFormat.Png); byte[] byteimage = ms.ToArray(); imgqrcode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteimage); } Phqrcode.Controls.Add(imgqrcode); } }
private void excelFileGetButton_Click(object sender, EventArgs e) { OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = "Excel 2003 (*.xls)|*.xls|Excel 2007 (*.xlsx)|*.xlsx"; dialog.InitialDirectory = @"d:\"; dialog.Title = "Please select an image file to encrypt."; if (dialog.ShowDialog() == DialogResult.OK) { string path = dialog.FileName; DataTable dt = reader.ExcelFile(path, "Sheet1"); accounts = dt.AsEnumerable().Select(dataRow => new Account() { Bank = dataRow[0].ToString(), ReqId = dataRow[1].ToString(), AccountNo = dataRow[2].ToString(), Name = dataRow[3].ToString(), Qty = Convert.ToInt32(dataRow[4]), Branch = (dataRow[5].ToString()), Currency = dataRow[6].ToString(), StartStNo = (dataRow[7].ToString()), EndStNo = (dataRow[8].ToString()), Routing = dataRow[9].ToString(), MICRAc = dataRow[10].ToString(), Type = dataRow[11].ToString(), }).ToList(); //accounts.Insert(0, new Account() { ReqId = dt.Columns[0].ColumnName, AccountNo = dt.Columns[1].ColumnName, Name = dt.Columns[2].ColumnName, Qty = Convert.ToInt32(dt.Columns[3].ColumnName), StartStNo = (dt.Columns[4].ColumnName), EndStNo = (dt.Columns[5].ColumnName), Routing = dt.Columns[6].ColumnName, Type = dt.Columns[7].ColumnName, Branch = dt.Columns[8].ColumnName }); foreach (Account account in accounts) { string s = ""; string a = ""; int serialNo = Convert.ToInt32(account.StartStNo); for (int i = 0; i < account.Qty; i++) { if (serialNo.ToString().Count() < 7) { a = "0" + serialNo; } s = null; s += account.Name + " " + account.AccountNo + " " + account.Routing + " " + a + " " + account.Branch; QRCoder.QRCodeGenerator qrGenerator = new QRCoder.QRCodeGenerator(); //QRCoder.QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(s, QRCodeGenerator.ECCLevel.l); QRCoder.QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(s, QRCoder.QRCodeGenerator.ECCLevel.H); Bitmap imgOutput = qrCode.GetGraphic(1); newAccounts.Add(new Account() { Bank = account.Bank, AccountNo = account.AccountNo, ReqId = account.ReqId, MICRAc = account.MICRAc, Currency = account.Currency, Branch = account.Branch, EndStNo = account.EndStNo, Name = account.Name, Qty = 1, Routing = account.Routing, Type = account.Type, StartStNo = a, Image = imgOutput }); //imgOutput = ResizeImage(imgOutput, imgOutput.Width, imgOutput.Height); ////Bitmap imgOutput = new Bitmap(@"D:\image.jpg"); //Graphics outputGraphics = Graphics.FromImage(imgOutput); //EncoderParameters myEncoderParameters = new EncoderParameters(3); //myEncoderParameters.Param[0] = new EncoderParameter(System.Drawing.Imaging.Encoder.Quality, 100L); //myEncoderParameters.Param[1] = new EncoderParameter(System.Drawing.Imaging.Encoder.ScanMethod, (int)EncoderValue.ScanMethodInterlaced); //myEncoderParameters.Param[2] = new EncoderParameter(System.Drawing.Imaging.Encoder.RenderMethod, (int)EncoderValue.RenderProgressive); //ImageCodecInfo[] codecs = ImageCodecInfo.GetImageEncoders(); //ImageCodecInfo ici = null; //foreach (ImageCodecInfo codec in codecs) //{ // if (codec.MimeType == "image/jpeg") // ici = codec; //} //imgOutput.Save(@"D:\Image\" + a +".jpg", ici, myEncoderParameters); //imgOutput.Save(@"D:\Image\" + a + ".jpg", ImageFormat.Jpeg); serialNo++; } } CreateExcel(newAccounts); dataGridView1.DataSource = newAccounts; MessageBox.Show("Successfully Done", "Message", MessageBoxButtons.OK); // spreadsheet.ImportFromList(newAccounts); } }