public static string ValidateCell(CellType type, string text) { if (type == CellType.s8) { if (!sbyte.TryParse(text, out _)) { return("Invalid value for signed byte."); } } else if (type == CellType.u8) { if (!byte.TryParse(text, out _)) { return("Invalid value for unsigned byte."); } } else if (type == CellType.x8) { try { Convert.ToByte(text, 16); } catch { return("Invalid value for hex byte."); } } else if (type == CellType.s16) { if (!short.TryParse(text, out _)) { return("Invalid value for signed short."); } } else if (type == CellType.u16) { if (!ushort.TryParse(text, out _)) { return("Invalid value for unsigned short."); } } else if (type == CellType.x16) { try { Convert.ToUInt16(text, 16); } catch { return("Invalid value for hex short."); } } else if (type == CellType.s32) { if (!int.TryParse(text, out _)) { return("Invalid value for signed int."); } } else if (type == CellType.u32) { if (!uint.TryParse(text, out _)) { return("Invalid value for unsigned int."); } } else if (type == CellType.x32) { try { Convert.ToUInt32(text, 16); } catch { return("Invalid value for hex int."); } } else if (type == CellType.f32) { if (!float.TryParse(text, out _)) { return("Invalid value for float."); } } else if (type == CellType.b8 || type == CellType.b32) { if (!bool.TryParse(text, out _)) { return("Invalid value for bool."); } } else if (type == CellType.fixstr || type == CellType.fixstrW) { // Don't see how you could mess this up } else { throw new NotImplementedException("Cannot validate cell type."); } return(null); }
private void btnDump_Click(object sender, EventArgs e) { BND4 bnd; try { bnd = SFUtil.DecryptDS3Regulation(txtRegulation.Text); } catch (Exception ex) { MessageBox.Show($"Failed to load regulation:\r\n\r\n{txtRegulation.Text}\r\n\r\n{ex}"); return; } var translations = new Dictionary <string, string>(); var xml = new XmlDocument(); xml.Load("translations.xml"); foreach (XmlNode text in xml.SelectNodes("translations/text")) { string jp = text.SelectSingleNode("jp").InnerText; string en = text.SelectSingleNode("en").InnerText; translations[WebUtility.HtmlDecode(jp)] = WebUtility.HtmlDecode(en); } var package = new ExcelPackage(); foreach (BinderFile file in bnd.Files) { if (Path.GetExtension(file.Name) == ".param") { PARAM64 param = PARAM64.Read(file.Bytes); string layoutPath = $"Layouts\\{param.ID}.xml"; txtStatus.AppendText(file.Name + "\r\n"); var worksheet = package.Workbook.Worksheets.Add(Path.GetFileNameWithoutExtension(file.Name)); PARAM64.Layout layout; if (File.Exists(layoutPath)) { layout = PARAM64.Layout.ReadXMLFile(layoutPath); if (layout.Size != param.DetectedSize) { layout = new PARAM64.Layout(); for (int i = 0; i < param.DetectedSize / 4; i++) { layout.Add(new PARAM64.Layout.Entry(CellType.u32, $"unk0x{i * 4:X4}", (uint)0)); } for (int i = 0; i < param.DetectedSize % 4; i++) { layout.Add(new PARAM64.Layout.Entry(CellType.u8, "unkb" + i, (byte)0)); } } } else { layout = new PARAM64.Layout(); } param.SetLayout(layout); List <PARAM64.Row> rows = param.Rows; worksheet.Cells[1, 1].Value = "ID"; worksheet.Cells[1, 2].Value = "Name"; worksheet.Cells[1, 3].Value = "Translated"; int columnCount = 3; foreach (PARAM64.Layout.Entry lv in layout) { if (lv.Type != CellType.dummy8) { worksheet.Cells[1, ++columnCount].Value = lv.Name; } } for (int i = 0; i < rows.Count; i++) { PARAM64.Row row = rows[i]; worksheet.Cells[i + 2, 1].Value = row.ID; if (row.Name != null) { if (translations.ContainsKey(row.Name)) { worksheet.Cells[i + 2, 2].Value = row.Name; worksheet.Cells[i + 2, 3].Value = translations[row.Name]; } else if (row.Name.Contains(" -- ")) { worksheet.Cells[i + 2, 2].Value = row.Name.Substring(row.Name.IndexOf(" -- ") + 4); worksheet.Cells[i + 2, 3].Value = row.Name.Substring(0, row.Name.IndexOf(" -- ")); } } else { worksheet.Cells[i + 2, 2].Value = row.Name; } columnCount = 3; foreach (PARAM64.Cell cell in row.Cells) { CellType type = cell.Type; if (type != CellType.dummy8) { var range = worksheet.Cells[i + 2, ++columnCount]; if (type == CellType.f32) { range.Value = (double)(float)cell.Value; } else if (type == CellType.b8 || type == CellType.b32) { bool b = (bool)cell.Value; range.Value = b.ToString(); range.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; range.Style.Fill.BackgroundColor.SetColor(b ? Color.LightGreen : Color.LightPink); } else if (type == CellType.x8) { range.Value = $"0x{cell.Value:X2}"; range.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right; } else if (type == CellType.x16) { range.Value = $"0x{cell.Value:X4}"; range.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right; } else if (type == CellType.x32) { range.Value = $"0x{cell.Value:X8}"; range.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right; } else { range.Value = cell.Value; } } } } worksheet.Row(1).Style.Font.Bold = true; worksheet.Column(1).Style.Font.Bold = true; worksheet.View.FreezePanes(2, 4); worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns(); } } FileInfo f = new FileInfo(Path.Combine(txtOutput.Text, "dump.xlsx")); package.SaveAs(f); }