Package com.independentsoft.office

# Class Util

java.lang.Object
com.independentsoft.office.Util

public class Util extends Object
The Class Util.

- ## Field Summary

  Fields
  Modifier and Type
  Field
  Description
  `static String`
  `MC`
  `static String`
  `P`
  `static String`
  `P14`
  `static String`
  `S`
  `static String`
  `W`

- ## Constructor Summary

  Constructors
  Constructor
  Description
  `Util()`

- ## Method Summary

  Modifier and Type
  Method
  Description
  `static String`
  `convertColumnIndex​(int column)`
  Convert column index.
  `static int`
  `convertColumnIndex​(String column)`
  Convert column index.
  `static String`
  `decodeEscapeCharacters​(String input)`
  Decode escape characters.
  `static String`
  `encodeEscapeCharacters​(String input)`
  Encode escape characters.
  `static String`
  `encodeEscapeCharactersWithSpecialCharacters​(String input)`
  Encode escape characters with special characters.
  `static String`
  `formatVmlNumber​(double value)`
  Formats a VML numeric value, omitting a redundant trailing ".0" for whole numbers (e.g.
  `static int`
  `getNextRandom()`
  Gets the next random.
  `static String`
  `getRelationshipFilePath​(String filePath)`
  Gets the relationship file path.
  `static String`
  `getRootExtraNamespacesAndIgnorable​(XMLStreamReader reader, Set<String> skipPrefixes)`
  Captures, from a part's root start element, the namespace declarations (excluding the default namespace and any prefix in `skipPrefixes` the caller already emits) plus an `mc:Ignorable` attribute, as a string to append to the re-emitted root tag.
  `static String`
  `hashPassword​(String password)`
  Hash password.
  `static boolean`
  `parseBoolean​(String input)`
  Parses the boolean.
  `static Date`
  `parseDate​(String utcDate)`
  Parses the date.
  `static Date`
  `parseDate​(String utcDate, String format)`
  Parses the date.
  `static int`
  `parseInt​(String value)`
  Parses an integer attribute value tolerantly: tries a plain integer first, then falls back to parsing a decimal (e.g.
  `static int`
  `parseInt​(String value, int radix)`
  Parses an integer attribute value in the given radix (e.g.
  `static int`
  `parseInteger​(String input)`
  Parses the integer.
  `static int`
  `parseIntegerPercent​(String input)`
  Parses the integer percent.
  `static String`
  `replaceFileNameEscapeCharacters​(String fileName)`
  Replace file name escape characters.
  `static String`
  `toLocalTime​(Date date)`
  To local time.
  `static String`
  `toUniversalTime​(Date date)`
  To universal time.
  `static String`
  `trim​(String input, String character)`
  Trim.

  ### Methods inherited from class java.lang.Object

  `clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

- ## Field Details

  - ### S

    public static String S

  - ### W

    public static String W

  - ### P

    public static String P

  - ### P14

    public static String P14

  - ### MC

    public static String MC

- ## Constructor Details

  - ### Util

    public Util()

- ## Method Details

  - ### formatVmlNumber

    public static String formatVmlNumber​(double value)
    Formats a VML numeric value, omitting a redundant trailing ".0" for whole numbers (e.g. the integer-valued o:spt shape-type id). `Double.toString` would render 202 as "202.0", which does not round-trip.
    Parameters:
      `value` - the value
    Returns:
      the formatted value

  - ### getRootExtraNamespacesAndIgnorable

    public static String getRootExtraNamespacesAndIgnorable​(XMLStreamReader reader, Set<String> skipPrefixes)
    Captures, from a part's root start element, the namespace declarations (excluding the default namespace and any prefix in `skipPrefixes` the caller already emits) plus an `mc:Ignorable` attribute, as a string to append to the re-emitted root tag. Round-trips MCE markers (e.g. `mc:Ignorable="x14ac"`) together with the namespaces they reference, so attributes such as `x14ac:knownFonts` / `x14ac:dyDescent` stay well-formed.
    Parameters:
      `reader` - positioned on the root start element
      `skipPrefixes` - prefixes already declared on the re-emitted root (may be null)
    Returns:
      the extra attribute string (each token has a leading space), or "" if none

  - ### parseInt

    public static int parseInt​(String value)
    Parses an integer attribute value tolerantly: tries a plain integer first, then falls back to parsing a decimal (e.g. fractional twips/EMU such as "11905.511811023622") and truncating toward zero, returning 0 when neither parses. Mirrors the C# Util.ParseInt (invariant-culture). Java's Integer/Double parsing is already locale-independent.
    Parameters:
      `value` - the attribute value
    Returns:
      the parsed integer, or 0 if it cannot be parsed

  - ### parseInt

    public static int parseInt​(String value, int radix)
    Parses an integer attribute value in the given radix (e.g. radix 16 for hex theme shade/tint), returning 0 when it cannot be parsed. Tolerant counterpart of Integer.parseInt(value, radix).
    Parameters:
      `value` - the attribute value
      `radix` - the radix
    Returns:
      the parsed integer, or 0 if it cannot be parsed

  - ### encodeEscapeCharacters

    public static String encodeEscapeCharacters​(String input)
    Encode escape characters.
    Parameters:
      `input` - the input
    Returns:
      the string

  - ### replaceFileNameEscapeCharacters

    public static String replaceFileNameEscapeCharacters​(String fileName)
    Replace file name escape characters.
    Parameters:
      `fileName` - the file name
    Returns:
      the string

  - ### encodeEscapeCharactersWithSpecialCharacters

    public static String encodeEscapeCharactersWithSpecialCharacters​(String input)
    Encode escape characters with special characters.
    Parameters:
      `input` - the input
    Returns:
      the string

  - ### decodeEscapeCharacters

    public static String decodeEscapeCharacters​(String input)
    Decode escape characters.
    Parameters:
      `input` - the input
    Returns:
      the string

  - ### convertColumnIndex

    public static String convertColumnIndex​(int column)
    Convert column index.
    Parameters:
      `column` - the column
    Returns:
      the string

  - ### convertColumnIndex

    public static int convertColumnIndex​(String column)
    Convert column index.
    Parameters:
      `column` - the column
    Returns:
      the int

  - ### trim

    public static String trim​(String input, String character)
    Trim.
    Parameters:
      `input` - the input
      `character` - the character
    Returns:
      the string

  - ### parseDate

    public static Date parseDate​(String utcDate)
    Parses the date.
    Parameters:
      `utcDate` - the utc date
    Returns:
      the date

  - ### parseDate

    public static Date parseDate​(String utcDate, String format)
    Parses the date.
    Parameters:
      `utcDate` - the utc date
      `format` - the format
    Returns:
      the date

  - ### toUniversalTime

    public static String toUniversalTime​(Date date)
    To universal time.
    Parameters:
      `date` - the date
    Returns:
      the string

  - ### toLocalTime

    public static String toLocalTime​(Date date)
    To local time.
    Parameters:
      `date` - the date
    Returns:
      the string

  - ### getNextRandom

    public static int getNextRandom()
    Gets the next random.
    Returns:
      the next random

  - ### getRelationshipFilePath

    public static String getRelationshipFilePath​(String filePath)
    Gets the relationship file path.
    Parameters:
      `filePath` - the file path
    Returns:
      the relationship file path

  - ### hashPassword

    public static String hashPassword​(String password)
    Hash password.
    Parameters:
      `password` - the password
    Returns:
      the string

  - ### parseBoolean

    public static boolean parseBoolean​(String input)
    Parses the boolean.
    Parameters:
      `input` - the input
    Returns:
      true, if successful

  - ### parseInteger

    public static int parseInteger​(String input)
    Parses the integer.
    Parameters:
      `input` - the input
    Returns:
      the int

  - ### parseIntegerPercent

    public static int parseIntegerPercent​(String input)
    Parses the integer percent.
    Parameters:
      `input` - the input
    Returns:
      the int